Question
How to grant a new user the same direct grant privilege as an existing user in sql
There is a new user that just joined our organization. I am trying to grant him the same direct grants privilege to the tables that the existing user has. The existing user has a ton of direct access privileges and it will take days if I had to do each grant one by one like: grant select,insert,delete,update on ttufiscal.pwrpwcm to XKY403. Is there a way of copying or inserting an existing user's privilege and granting it to a new user.
Thanks
Add a comment
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×