Knowledge Base
Monday, June 29, 2015
DB Table Grants
For each table under DB
schema must be next granting clause, so in USER can access and modify data inside that table:
GRANT
SELECT
ON
<TABLE_NAME>
TO
QUERY_ROLE
;
GRANT
DELETE,
INSERT,
SELECT,
UPDATE
ON
< TABLE_NAME>
TO
UPDATE_ROLE
;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment