Other (Role & User & Privilege)

First, grant permission GRANT privilege [,...] ON object [,...] TO {PUBLIC | GROUP group | username} II. Revoke permission REVOKE | [()] [ON]

FROM |

[CASCADE CONSTRAINTS]

Note: if a user obtains a permission through the WITH GRANT OPTION clause, the user can also use the WITH GRANT OPTION clause to grant other user rights, which may result in a long list of grantees, but permissions are not allowed to be granted recursively. If the owner revokes a permission from a user who grants it to another user, the revocation is cascaded to all granted permissions.

For WITH ADMIN OPTION system permissions, parent permissions are reclaimed, and child permissions are not cascaded.

For object permissions of WITH GRANT OPTION, parent permissions are reclaimed, and child permissions are cascaded.

3. View USER creation information SELECT A.USERNAME

A.DEFAULT_TABLESPACE

A.TEMPORARY_TABLESPACE

TO_CHAR (A.CREATED, 'yyyy-mm-dd hh34:mi:ss')

A.PROFILE

FROM DBA_USERS A

WHERE USERNAME =''

SELECT * FROM DBA_TS_QUOTAS A; IV. View user status information SELECT A.USERNAME

A.ACCOUNT_STATUS

TO_CHAR (A.LOCK_DATE, 'yyyy-mm-dd hh34:mi:ss')

TO_CHAR (A.EXPIRY_DATE, 'yyyy-mm-dd hh34:mi:ss')

FROM DBA_USERS A; 5. View profile content SELECT * FROM DBA_PROFILES WHERE PROFILE = 'PF_EAGLE'; 6. Get the user creation statement SELECT DBMS_METADATA.GET_DDL (' USER', 'SCOTT').

FROM DUAL

UNION ALL

SELECT DBMS_METADATA.GET_GRANTED_DDL ('SYSTEM_GRANT',' SCOTT')

FROM DUAL

UNION ALL

SELECT DBMS_METADATA.GET_GRANTED_DDL ('OBJECT_GRANT',' SCOTT')

FROM DUAL

UNION ALL

SELECT DBMS_METADATA.GET_GRANTED_DDL ('ROLE_GRANT',' SCOTT')

FROM DUAL