Use the SQL statement below to answer the question that follow:connect sys/oracle as sysdbagrant create table, create sequence to user0 with admin option;connect user0/password grant create table, create sequence to user1;connect sys/oracle as sysdbarevoke create table from user0;After the last statement, which of the following is/are TRUE A. user1's create sequence privilege cannot be revoked by user0 B. user0 can create sequences C. user0 can revoke the create table privilege from user1 D. user1 can create tables
Question
Use the SQL statement below to answer the question that follow:connect sys/oracle as sysdbagrant create table, create sequence to user0 with admin option;connect user0/password grant create table, create sequence to user1;connect sys/oracle as sysdbarevoke create table from user0;After the last statement, which of the following is/are TRUE A. user1's create sequence privilege cannot be revoked by user0 B. user0 can create sequences C. user0 can revoke the create table privilege from user1 D. user1 can create tables
Solution
A. True - User1's create sequence privilege cannot be revoked by User0 because the privilege was granted by sysdba, not User0.
B. True - User0 can create sequences. The revocation of the create table privilege from User0 does not affect the create sequence privilege.
C. False - User0 cannot revoke the create table privilege from User1. User0 no longer has the create table privilege, so they cannot revoke it from others.
D. True - User1 can create tables. The privilege was granted to User1 by User0 before the create table privilege was revoked from User0 by sysdba. The revocation of the privilege from User0 does not affect the privileges that User0 had already granted to User1.
Similar Questions
Which action allows the DBA to grant specific privileges to user accounts?Question 1Answera.Privilege revocationb.Account suspensionc.Privilege grantingd.Account creation
Write a SQL script that creates a table users following these requirements:With these attributes:id, integer, never null, auto increment and primary keyemail, string (255 characters), never null and uniquename, string (255 characters)If the table already exists, your script should not failYour script can be executed on any database
Which of the following options can be used with the useradd command to create a user with no login permissions?Select one:a.-Gb.-Uc.-Nd.-L
Which of the following options can be used with the useradd command to create a user with no login permissions?Select one:a.-Gb.-Nc.-Ud.-L
What command is used to create a new table in SQL?OptionsNone of theseBUILD TABLECREATE TABLEGENERATE TABLE
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.