First you need to create a table space, and then create a user name, the user name to give him a table space, and give the user permissions,
DBA: Has full privileges, is the highest system privilege, and only the DBA can create the database structure. RESOURCE: A user with RESOURCE permission can only create entities and cannot create a database structure. Connect: A user with connect permission can only log on to Oracle, not create an entity, and cannot create a database structure. For normal users: Grant Connect, resource permissions.
For DBA administration users: Grant Connect,resource, dba authority. The author believes that after the execution of a statement is a failure will also establish a user, so use plsql when executing user statements to refresh the user list, the user you think is a failure to delete
/*CREATE table space, keyword: tablespace*/Createtablespace llc_data/*logging log keyword, in addition to a nologging keyword, will be in the next study and share with you*/Logging/*The location of the log file (also called the tablespace), in addition, another keyword is tempfile, which means that the temporary tablespace*/datafile'D:\database\llc_data.dbf'/*size 50m*/size 50m/*autoextend: Self-growth, next 50m: Every 50m,maxsize 20480m: Max 20480m*/Autoextend onNext50m maxsize 20480m/*Local Management table space, in Oracle database: Extent management There are two ways to extent management local (locally managed), Extent management dictionary (data Dictionary Management), The Local management table space significantly improves management efficiency and database performance compared to the Dictionary management table space, which defaults to Local*/extent management Local;/*execute the above before performing the following*//*Create a User LLC*/Create UserLLC/*Password is 123456*/identified by"123456"/*The default table space is: Llc_data*/defaulttablespace "Llc_data";/*Grant: Authorization keyword, general user does not recommend authorizing DBA*/GrantConnect,resource,dba toLlc
Oracle Learning One (ongoing update)