Difference between revisions of "GRANT"
Jump to navigation
Jump to search
| Line 7: | Line 7: | ||
GRANT SELECT ON sales TO scott WITH GRANT OPTION' | GRANT SELECT ON sales TO scott WITH GRANT OPTION' | ||
GRANT UPDATE ON sales TO scott | GRANT UPDATE ON sales TO scott | ||
[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | [[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | ||
Latest revision as of 17:36, 14 November 2017
GRANT command can be used to grant schema object privileges to roles or to users With GRANT OPTION enables the grantee to pass on his privileges
GRANT SELECT, INSERT, DELETE ON sales TO scott;
GRANT ALL ON sales TO scott;
GRANT SELECT ON sales TO scott WITH GRANT OPTION'
GRANT UPDATE ON sales TO scott