Difference between revisions of "GRANT"

From rbachwiki
Jump to navigation Jump to search
(Created page with "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, DELE...")
 
 
(One intermediate revision by the same user not shown)
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

Back To Top- Home - Category