Explain the unlimited tablespace system permissions of Oracle

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.