Tuesday, July 24, 2007

PL/SQL: User Privileges are not inherited from roles


FACT: When executing DDL from withing PL/SQL using NDS, then the user running the procedure must have the appropriate privilege assigned directly to create a whatever object the DDL is trying to create.



Privileges are not inherited from a role if a procedure is used.

0 comments:

Post a Comment