Background: oracle 9.2.0 running on win2k
I got 2 logical userids
--given RESOURCE, CONNECT roles and owned all the user created objects such as tables, indexes, sequences, etc. This userid is shared by 3 physical developers
--given CONNECT,CREATE SYNONYM roles and physically shared by 4-5 end application users. End application users manipulate the data via application interface. That is, they logon, logoff, delete, insert, delete data via application, they do not have command line to execute SQL
Everytime, OPTELADMIN had tested the application & is ready to let OPTEL used the new tables, i had to do 2 things
A) Create the synonym, for OPTEL to use the tables,eg,
CREATE SYNONYM Cust FOR opteladmin.Cust;
B) Create the grants, for OPTEL to manipulate the tables, eg,
GRANT SELECT, INSERT, UPDATE, DELETE ON Cust TO optel;
This is very manual. Is there any suggestion how i can automate this?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!