ORA-01031: insufficient privileges ORA-06512 at SYSTEM

[former_member209962]

Dear All,

We are getting below error when we are trying to create table at database level with user SYSTEM

we have created some connections with user SYSTEM and that user is not having sufficient privileges please let me know the command to give full privileges to user SYSTEM.

ORA-01031: insufficient privileges ORA-06512 at SYSTEM

Kindly help

Thanks

Tabarayz

[Former Member]

Hi Tabarayz,

Could you execute the statement and paste the result, here;

select granted_role from dba_role_privs where grantee in ('SYSTEM');

Best regards,

Orkun Gedik

[former_member209962]

Dear Orkun,

Thanks for yourt quick reply please finf below requested information

C:\Users\nfdadm>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on Thu Mar 7 12:37:19 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select granted_role from dba_role_privs where grantee in ('SYSTEM');

GRANTED_ROLE

------------------------------

AQ_ADMINISTRATOR_ROLE

SAPDBA

DBA

SQL> commit;

Commit complete.

SQL> exit

[former_member209962]

please below info also its showin create_table  NO

SQL> select * from dba_sys_privs where GRANTEE='SYSTEM';

GRANTEE                        PRIVILEGE                                ADM

------------------------------ ---------------------------------------- ---

SYSTEM                         GLOBAL QUERY REWRITE                     NO

SYSTEM                         CREATE MATERIALIZED VIEW                 NO

SYSTEM                         CREATE TABLE                             NO

SYSTEM                         UNLIMITED TABLESPACE                     YES

SYSTEM                         SELECT ANY TABLE                         NO

[Former Member]

Hi,

"dba_sys_privs" are correct. Could you execute the statement and try to create the table, again?

grant CREATE TABLE to SYSTEM;

Best regards,

Orkun Gedik

[Former Member]

As well as please execute

grant update, delete to system;

[former_member209962]

Dear Orkun,

Thanks for your help problem solved after running below command.

grant create view to system;

Thanks

Tabrayz