user previlige

client:用户无法登录。
SQL> connect admin/admin@db01;
ERROR:
ORA-12541: TNS:no listener


server:
经过检查，linstner是OK的，
sqlplus admin/admin@db01
报告没有create session权限，
SQL> select * from dba_role_privs where grantee='ADMIN';

no rows selected

SQL> grant connect to admin;

Grant succeeded.

SQL> select * from dba_role_privs where grantee='ADMIN';

GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
ADMIN CONNECT NO YES



系统权限：user_sys_privs;
对象权限：user_tab_privs;