GRANT

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