]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Charu
Joshi
Sent: Tuesday, October 28, 2003
5:55 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: dynamic sql problem
Siddharth,
All roles are disabled in any named PL/SQL block
(stored
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
Your
account probably has the create table privilege granted through the resource
role, grant create table to your account and try again, privileges granted
through a role are not active when running a procedure.
-Original Message-From: Siddharth Haldankar
[mailto:[EMAIL PROTECT
Title: Mensagem
to use
it inside packages u must have some priviledges given directly to u not to a
role.
Regards
PG
-Mensagem original-De: Siddharth Haldankar
[mailto:[EMAIL PROTECTED] Enviada: terça-feira, 28 de Outubro de
2003 11:39Para: Multiple recipients of list
Hi there,
It could just be that you are missing your semicolons ';' off the end of
your statements.
Cheers,
Kev.
__
Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
Tel: 0141 568 2314
Fax: 0141 568 2366
http://www.calanais.com
-Original Message-
Sen
Which is the problem statement? I didn't see the bold.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Harvinder Singh
