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.
You might also like to view...
A mouse motion listener class can respond to:
A) The mouse button is clicked on B) The mouse cursor exits a component's screen space C) The mouse moved D) The mouse button is released
What are four actions team members take in Scrum?
What will be an ideal response?
Which of the following is true regarding VBScript arrays?
a) VBScript arrays can be dynamically allocated. b) VBScript arrays must be declared with the upper bound specified. c) The statement ReDim is used to clear the contents of an array. d) The statement UBound is used to resize the dimension of the array.
________ buttons are used to display Excel sheet tabs not in view
A) Tab scrolling B) Show/Hide C) Zoom D) View