Give a user authority to pass along the privileges
SQL> GRANT select, insert
2 ON dept
3 TO scott
4 WITH GRANT OPTION;
Grant succeeded.
Allow all users on the system to query data from Alice’s DEPT table.
SQL> GRANT select
2 ON alice.dept
3 TO PUBLIC;
Grant succeeded.
SQL> GRANT select, insert
2 ON dept
3 TO scott
4 WITH GRANT OPTION;
Grant succeeded.
Allow all users on the system to query data from Alice’s DEPT table.
SQL> GRANT select
2 ON alice.dept
3 TO PUBLIC;
Grant succeeded.
No comments:
Post a Comment