grant required to create the table through API [message #270968] |
Fri, 28 September 2007 10:34  |
kukreja
Messages: 33 Registered: February 2007
|
Member |
|
|
Hi
I create a user test through sys dba.
Then provide grants
grant resource to test;
grant create session to test;
And create a procedure test1
create or replace procedure test1
is
begin
execute immediate 'create table check(a number)';
end;
While executing this procedure test1 i got this error
execute test1;
BEGIN test1; END;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "AD.TEST1", line 4
ORA-06512: at line 1
can anyone help me to sort out this problem.
|
|
|
|
|
Re: grant required to create the table through API [message #270975 is a reply to message #270973] |
Fri, 28 September 2007 10:46   |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Michel Cadot wrote on Fri, 28 September 2007 17:37 | Roles are not enabled in stored procedure.
Roles are not enabled in stored procedure.
Roles are not enabled in stored procedure.
Roles are not enabled in stored procedure.
Roles are not enabled in stored procedure.
Roles are not enabled in stored procedure.
Roles are not enabled in stored procedure.
Roles are not enabled in stored procedure.
Roles are not enabled in stored procedure.
Roles are not enabled in stored procedure.
Roles are not enabled in stored procedure.
Roles are not enabled in stored procedure.
Roles are not enabled in stored procedure.
Roles are not enabled in stored procedure.
Roles are not enabled in stored procedure.
Roles are not enabled in stored procedure.
Roles are not enabled in stored procedure.
Regards
Michel
|
Remove the "create table" privilege you just granted and then try "set role none;" and "create table".
Regards
Michel
[Updated on: Fri, 28 September 2007 10:47] Report message to a moderator
|
|
|
Re: grant required to create the table through API [message #270978 is a reply to message #270968] |
Fri, 28 September 2007 10:53   |
kukreja
Messages: 33 Registered: February 2007
|
Member |
|
|
ok ok michel
any alternative solution to my problem.
Through resource role without direct grants
if i able to create table through stored procedure.
Also even if i grant
grant create table to test
I am not able to access this table check through stored procedure.
I got this error
ORA-00942: table or view does not exist
[mod-edit] removed illiterate IM speak.
[Updated on: Fri, 28 September 2007 12:37] by Moderator Report message to a moderator
|
|
|
|
|