Hello,
I need give permission to db for user, which in application has permission only to one company - in instalation is a lat of companies.
And next question, how I can give him permissions to view procedures in pl/sql developer
Regards
Paulina
“how I can give him permissions to view procedures in pl/sql developer”
As per my understand database objects access cannot be control via application side. You need to create a oracle user and grant view/edit access to this user to specific procedures, packages etc.. Hope I understood your requirement correctly.
Please refer these links
https://reintech.io/blog/sql-grant-and-revoke-statements-guide
https://beginner-sql-tutorial.com/sql-grant-revoke-privileges-roles.htm
Regards,
Sahan
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.