Siddharth,
All roles are disabled in any named PL/SQL block (stored
procedure, function, or trigger) that executes with definer rights. The SESSION_ROLES view shows all roles that are
currently enabled. If a named PL/SQL block that executes with definer rights queries
SESSION_ROLES, the query does not return any rows. Named PL/SQL blocks that execute with invoker rights and
anonymous PL/SQL blocks are executed based on privileges granted through enabled roles.
So the problem might be that you have been granted 'CREATE TABLE' through a role and not directly. Regards, Charu.
********************************************************* Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. ********************************************************* Visit us at http://www.mahindrabt.com |
- dynamic sql problem Harvinder Singh
- Re: dynamic sql problem DBarbour
- RE: dynamic sql problem Thomas, Kevin
- dynamic sql problem Siddharth Haldankar
- RE: dynamic sql problem Paulo Gomes
- RE: dynamic sql problem McBain, Neil SITI-ITDIEEE
- RE: dynamic sql problem Charu Joshi
- RE: dynamic sql problem Siddharth Haldankar