Name Oracle9i’s object privileges. What is used to grant all object privileges? What is used to grant privileges to everybody?
What will be an ideal response?
Object privileges:
? ALTER (table, sequence)
? INSERT (table, view)
? UPDATE (table, view)
? DELETE (table, view)
? SELECT (table, view, sequence)
? REFERENCES (table, view)
? INDEX (table)
? EXECUTE (procedure, function, package, library, user-defined type)
? UNDER (view, user-defined type)
? READ (directory)
? WRITE (directory)
Keyword ALL is used to grant all privileges on an object.
Keyword PUBLIC is used to grant object privileges on an object to all users.
Computer Science & Information Technology
You might also like to view...
In Outline view, the Outlining tab displays:
A) below the document. B) on the left side of the document. C) on the right side of the document. D) in the Ribbon.
Computer Science & Information Technology
What is the cost of external sorting?
What will be an ideal response?
Computer Science & Information Technology