ITPub博客

alter user set role create_table not default alter user test default role resourcealter user test default role allalter user test default role all except resourcehttp://blog.oracle.com.cn/html/82/t-127982.htmlhttp://www.orafaq.com/forum/t/76312/0/[@more@]阿斯顿

http://203.208.39.132/search?q=cache:HWVo-k7-Qd8J:www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/statements_4003.htm+alter+user+default+role+all+except&cd=2&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy2_P-vPWNNI9YlOWQTrNdipSu_5X9w[@more@]alter user test default role all except create_table; 什么意思？Select * from dba_role_privs中存在default 属性，缺省给用户授予的角色都是yes,就是logon以后可以使用的，如果是no的，需要在会话中 问题：角色授权的时候

View the Exhibit to observe the privileges granted to the MGR_ROLE role. The SCOTT user has beenwww.supportcenter.cnhttp://www.supportcenter.cngranted the CONNECT and RESOURCE roles only.The database administrator (DBA) grants MGR_ROLE to the SCOTT user by using this command:SQL> GRANT MGR_ROLE TO SCOTT WITH ADMIN OPTION;Which statement is true about the SCOTT user after he is granted this role?[@more@]A) The SCOTT user can grant the MGR_ROLE role and the privileges in it to other users.B) Th