Explain the unlimited tablespace system permissions of Oracle

Source: Internet
Author: User

1.System PermissionsUnlimited tablespaceIs hidden inDba, resourceA system permission in the role. When the user obtains the role of dba or resource,The unlimited tablespace system permission is also implicitly authorized to the user.

2.System PermissionsUnlimited tablespaceCannot be grantedRole,Can be granted to users.

3.System PermissionsUnlimited tablespaceWill not followResource, dbaGrantedRoleAnd grant it to the user.

1Lab1

SQL>Create user u1 identified by u1;

User created.

SQL>Grant connect, resource to u1;

Grant succeeded.

SQL>Select * from dba_role_privs a where a. grantee = 'u1 ';

GRANTEEGRANTED_ROLEADM DEF

----------------------------------------------

U1RESOURCENOYES

U1CONNECTNOYES

SQL>Select * from dba_sys_privs a where a. grantee = 'u1 ';

GRANTEEPRIVILEGEADM

-------------------------------------------

U1UNLIMITED TABLESPACENO

SQL>Revoke unlimited tablespace from u1;

Revoke succeeded.

SQL>Select * from dba_sys_privs a where a. grantee = 'u1 ';

No rows selected

2Lab2

SQL>Create role r1;

Role created.

SQL>Grant unlimited tablespace to r1;

ORA-01931: Cannot grant unlimited tablespace to a role

Cannot be authorized to a roleR1.

 

SQL>Grant unlimited tablespace to u1;

Grant succeeded.

Authorized to usersU1.

3Lab3

SQL>Revoke resource from u1;

Revoke succeeded.

SQL> grant resource to r1;

Grant succeeded.

SQL>Grant r1 to u1;

Grant succeeded.

SQL>Select * from dba_role_privs a where a. grantee = 'u1 ';

GRANTEEGRANTED_ROLEADM DEF

----------------------------------------------

U1R1 NOYES

U1CONNECTNOYES

SQL> select * from dba_sys_privs a where a. grantee = 'u1 ';

No rows selected

The system permission does not exist.Unlimit tablespaceSystem Permissions.

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.