Oracle__2. Oracle 1Z0-051 Exam - Privileges Flashcards
What happens to transactions if a GRANT command is executed?
An implicit commit will be execute before the GRANT command.
What happens to transactions if an ALTER VIEW is executed?
An implicit commit will be execute before the ALTER VIEW command.
What privileges does the user Scott have after this statement is executed? CREATE USER scott IDENTIFIED BY tiger
no privileges
What is the password for scott after this statement is executed? CREATE USER scott IDENTIFIED BY tiger
tiger
What is allowed after this statement is executed? GRANT SELECT, INSERT, UPDATE ON student_grade TO manager WITH GRANT OPTIONS
The role/user manager can give select or insert or update privileges to the table student_grade to others
Can only an owner change an object?
No. Permissions can be granted to others
What is the syntax for creating a Role?
CREATE ROLE rolename
What is the syntax for granting select and update on TABLEA for user USER1?
GRANT SELECT, UPDATE ON tablea TO user1
What is the syntax for creating user USER1 with password1?
CREATE USER User1 IDENTIFIED BY password1.
What Command is the opposite of GRANT?
REVOKE
What is the syntax to grant SELECT access to all users for Table1?
GRANT SELECT ON table1 TO PUBLIC
What privilege is needed for a user to delete records or truncate a table?
DELETE ANY TABLE
What is the syntax to give the create table and create view to the manager role?
GRANT CREATE TABLE, CREATE VIEW TO manager
What does the WITH GRANT OPTION clause allow?
The grantee (user or role) can grant privileges to other users or role
What privileges is granted to a user/role to allow deletes and truncates on a table?
DELETE ANY TABLE
