Execute privilege at the database level
Posted by:
Kyle Murphy
Date: September 25, 2009 11:45AM
I have created a user and assigned the Execute privilege at the DATABASE level.
When attempting to CALL any stored procedure under this database, I would expect the database-level Execute privilege to allow execution on this procedure. Instead, I am forced to give Execute privilege to each Stored Proc individually for it to work. This is a real pain.
What is the purpose of the Execute privilege at the DATABASE level? I would expect each stored procedure to inherit the database-level Execute privilege, thus preventing me to have to explicitly give Execute permissions at the stored proc level.
Subject
Views
Written By
Posted
Execute privilege at the database level
4700
September 25, 2009 11:45AM
2479
September 25, 2009 11:48AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.