You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
10 lines
279 B
Plaintext
10 lines
279 B
Plaintext
--Grant on a table
|
|
GRANT SELECT, INSERT ON TABLE tbl1 TO user
|
|
|
|
--Grant execution on a stored procedure
|
|
GRANT EXECUTE ON PROCEDURE prc1(INT, DATE) TO USER jdoe
|
|
GRANT EXECUTE ON SPECIFIC PROCEDURE mypr TO GROUP admins
|
|
|
|
--Revoke on a table
|
|
REVOKE DELETE ON TABLE mytable FROM recur
|