Oracle Learning One (ongoing update)

Source: Internet
Author: User

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)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.