I need that the user does not have access to another scheme, but the stored procedure could access a different schema.
Oracle – How to grant to stored procedure, privileges to select from a different schema
grantoracleoracle10gplsqlschema
Related Topic
- Mysql – Why is a “GRANT USAGE” created the first time I grant a user privileges
- Oracle – Java Stored Procedure Vs PL/SQL Stored Procedure
- Mysql – grant remote access of MySQL database from any IP address
- Oracle – how to grant role acces to specific schema
- Postgresql – What does GRANT USAGE ON SCHEMA do exactly
- Mysql – How to grant execute on specific stored procedure to user
Best Answer
What you are describing is not possible.
If
b.procedure
can select, insert, update or delete ona.table
, then anyone logged in asb
could do so too.What you should do instead is create procedure
a.procedure
andgrant execute on a.procedure to b
.