ORACLE permissions, with admin option and small operations

The individual understands Oracle permissions as three classes, System permissions, object permissions, and session permissions.
Correspond separately:
Dba_sys_privs;
Dba_tab_privs:
Session_privs;

Of course there's role,

Dba_role_privs;
Role_sys_privs;

Distinction is very good distinction, create,execute, such as system permissions, update, etc. belong to object permissions.

+++++++++++++++++++++++++++++++++++++++++++
How to view a user and what role it has.

SELECT * from Dba_role_privs where grantee= ' username '  

View the number of permissions each role has:

Select Role,count (*) from ROLE_SYS_PRIVS GROUP by role;

See which users have SYSDBA or Sysoper system permissions (requires appropriate permissions when querying)

++++++++++++++++++++++++++++++++++++++++++++ for with admin option/with grant Option 2, just remember, if revoke, Grant was recovered in a joint. for an ordinary user to be granted:

Grant Connect,resource,create view to User1;

10g start, connect inside only create Session permission, resource permissions did not create view. Also need to highlight the next is unlimited tablespace (the above experiment, granted the resource permission to User1, User1 actually automatically have unlimited tablespace permissions)

Characteristics of unlimited tablespace:
1, System permissions unlimited tablespace can not be granted role, can only be granted to the user. In other words, unlimited tablespace system permissions cannot be included in a role
2. Unlimited tablespace is not included in resource role and DBA role, but unlimited tablespace is granted to users with resource or DBA grants. That is to say, if a role is granted to a user, then the user will have unlimited tablespace system privileges
3, unlimited tablespace can not accompany this resource was granted role and granted to the user. That is, the resource role was granted to the Role_test role and Role_test was granted to the test user, but at this point unlimited tablespace was not granted the test user

PS: Miscellaneous Repair
+++++++++++++++++++++++++++++++++++

To edit the previous SQL command:

The Glogin.sql file in $oracle_home/sqlplus/admin added:

Define _editor=vi

The C1 columns of the T1 table want to be sorted according to the order of the first letter:

select * from T1 ORDER by Nlssort (C1, ' Nls_sort=schinese_pinyin_m ');