Home » RDBMS Server » Security » insufficient priv's
insufficient priv's [message #43675] Mon, 18 August 2003 05:58 Go to next message
Vishv
Messages: 1
Registered: August 2003
Junior Member
while executing procedure i am getting this error.

though i have all the privileges with which i can create procedures/tables/views

The following error has occurred:

ORA-01031: insufficient privileges
ORA-06512: at "BOHRDB.CHEKCK", line 5
ORA-06512: at line 2

the sequence of the procedure is in this way

BEGIN
EXECUTE IMMEDIATE 'drop table bo_ohr_exit_dump';
END;

COMMIT;

BEGIN
EXECUTE IMMEDIATE 'rename bo_ohr_temp to bo_ohr_exit_dump';
END;

BEGIN
EXECUTE IMMEDIATE 'create table bo_ohr_temp as select * from bo_ohr_exit_Data WHERE 1=2';
END;

drop and rename commands r working fine but while creating its showing me this error,

if i issue the same command in sqlplus, it works but not in this procedure.
Re: insufficient priv's [message #43678 is a reply to message #43675] Mon, 18 August 2003 07:22 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
You need to have received the privs directly and not through a role. Check how the privs are given to you (via dictionary views USER_ROLE_PRIVS, USER_TAB_PRIVS_RECD)

MHE
Re: insufficient priv's [message #43699 is a reply to message #43678] Wed, 20 August 2003 03:48 Go to previous message
R.Satish Kumar
Messages: 14
Registered: August 2003
Junior Member
Hi,

You need to have 'Create Any Table' Privilege to
execute this..

Try to get this privilege and execute the procedure.

Cheers,
Satish.R
Previous Topic: Check whether default password has been changed by user
Next Topic: A random password generator
Goto Forum:
  


Current Time: Sat Aug 15 15:17:32 CDT 2020