单项选择题
A.The user must enable the role explicitly.
B.The user can grant the role to other users.
C.The user cannot use the role until the DBA enables it explicitly.
D.The user can start using the role immediately without any changes.
单项选择题 View the Exhibit and examine the user information. The user has been granted CONNECT and RESOURCE roles and no individual system privileges. TheSL_REP user executes this command to create a table: SQL> CREATE TABLE orders(oid number(6), odate date, ccode number(4), oamt number(10,2)) TABLESPACE purchase_space; The PURCHASE_SPACE tablespace already exists in the database. Which statement describes theeffect of the command()
单项选择题 You want to create a role to meet these requirements: 1:The role is to be protected from unauthorized usage. 2:The password of the role is not to be embedded in the application source code or stored in a table. Which method would you use to restrict enabling of such roles()
单项选择题 Examine the commands executed in the following sequence: 1:SQL> CREATE ROLE mgrrole; 2:SQL> GRANT create user,select any table,connect,resource TO mgrrole; 3:SQL> GRANT select,update ON sh.sales TO mgrrole; 4:SQL> CREATE ROLE ceo IDENTIFIED BY boss; 5:SQL> GRANT mgrrole,drop any table,create any directory TO ceo; 6:SQL> GRANT ceo TO mgrrole; Which statement is true about the above commands()