分类: Oracle
2010-06-03 13:11:45
GRANT privilege[,privilege2,...] TO user[,user2,...] [WITH ADMIN OPTION]; |
GRANT privilege,[privilege2,...] | ALL [(column[,column,...])] ON objectname TO user | role | PUBLIC [WITH GRANT OPTION]; |
对象权限 |
授予对象 |
SELECT |
表、视图、序列 |
INSERT |
表、视图 |
UPDATE |
表、视图 |
ALTER |
表、序列 |
INDEX |
表 |
REFERENCES |
表 |
EXECUTE |
过程、函数、程序包 |
DELETE |
表、视图 |
REVOKE privilege [,privilege,...] FROM username [,username,...]; |
REVOKE privilege,[privilege2,...] | ALL [(column[,column,...])] ON objectname FROM user | role | PUBLIC [CASCADE CONSTRAINTS]; |
GRANT CONNECT,RESOURCE TO user; |