* Object에 따른 Privileges
|
객체권한 |
테이블 |
뷰 |
Sequence |
Procedure |
|
ALTER |
○ |
|
○ |
|
|
DELETE |
○ |
○ |
|
|
|
EXECUTE |
|
|
|
○ |
|
INDEX |
○ |
|
|
|
|
INSERT |
○ |
○ |
|
|
|
REFERENCES |
○ |
|
|
|
|
SELECT |
○ |
○ |
○ |
|
|
UPDATE |
○ |
○ |
|
|
Object-level access privileges
|
Privilege |
Enables user to |
|
ALTER |
Change the definition of an object. |
|
DELETE |
Remove rows from a table or view's base table. |
|
EXECUTE |
Execute a procedure, function, or Java source. |
|
INDEX |
Create an index on a specified table or view. |
|
INSERT |
Insert rows into a table or a view's base table. |
|
REFERENCES |
Create a constraint on a table or view. |
|
SELECT |
Retrieve data from one or more tables or views. |
|
UPDATE |
Change existing values in a table or view's base table. |
-
You can assign the With Grant Option to database users or Public, but not to database roles.
-
You cannot grant the INDEX and REFERENCES object-level privileges to a database role.