srikotesh
asked on
help me to understand the synonym concept while providing grant permissions to users
There is a table test created by info user.
To provide permissions to other user below is the syntax i have used.
create or replace synonym info1.test for info.test
GRANT SELECT,INSERT,UPDATE,ALTER ,DELETE ON info.test TO info1
is it mandatory to create synonym while granting permissions to other user?
suggest me how it helps.
To provide permissions to other user below is the syntax i have used.
create or replace synonym info1.test for info.test
GRANT SELECT,INSERT,UPDATE,ALTER
is it mandatory to create synonym while granting permissions to other user?
suggest me how it helps.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for valuable suggestions.
which statement i need to give first.
is there any order first grant then synonym or
synonym then grant
create or replace synonym info1.test for info.test
GRANT SELECT,INSERT,UPDATE,ALTER