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