aldovalerio
Programmer
I would like to pass on Oracle messages to users telling them that they don't have privileges to execute a procedure, but the messages seem very cryptic for users: "PLS-00201: identifier 'schema_name.procedure_name' must be declared". Isn't it possible to get a more descriptive message?
I've got 2 user roles, ROLE_USER and ROLE_READONLY_USER. I granted the former EXECUTE permission on all procedures, and the latter EXECUTE permission only on non-data-modifying procedures. I added the second role recently in an attempt to introduce application-level security without modifying my Visual Basic client app.
I've got 2 user roles, ROLE_USER and ROLE_READONLY_USER. I granted the former EXECUTE permission on all procedures, and the latter EXECUTE permission only on non-data-modifying procedures. I added the second role recently in an attempt to introduce application-level security without modifying my Visual Basic client app.
