SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Insufficient privileges

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Insufficient privileges
Author Message
buatt



Joined: 05 Jan 2004
Posts: 1

Post Insufficient privileges Reply with quote

Hi to all,

I'm trying your DBTools on my Oracle 9.0.1 server (P3-500 Mhz - 750Mb RAM on SuSE Linux 7.2). Your tools are really great and all denotes a great care to create it.
I execute the DB database setup wizard using "084 ORACLE 8.0.4 - 8.1.X" driver and the SYSTEM account so I go next >>>> until I have an error: "Error executing GRANT command. You do not have sufficient privileges to execute this command. Please logon as SYS user and try again. ORA-01031 insufficient privileges". The command is "GRANT EXECUTE ON sys.dbms_sql TO ora_monitor".
If i go back to login page and use SYS account then I receive message: "ORA-28009: connection to sys should be as sysdba or sysoper" but I cannot write "sys as sysdba" in the user field (invalid username/password). What should I do?

Mon Dec 17, 2001 6:29 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Re: Insufficient privileges Reply with quote

You can ignore that message. This is needed only for compatibility with old versions of Oracle or incomplete installation. In your case, DBMS_SQL should be already granted to PUBLIC.

: Hi to all,

: I'm trying your DBTools on my Oracle 9.0.1 server (P3-500 Mhz - 750Mb RAM on
: SuSE Linux 7.2). Your tools are really great and all denotes a great care
: to create it.
: I execute the DB database setup wizard using "084 ORACLE 8.0.4 -
: 8.1.X" driver and the SYSTEM account so I go next >>>>
: until I have an error: "Error executing GRANT command. You do not
: have sufficient privileges to execute this command. Please logon as SYS
: user and try again. ORA-01031 insufficient privileges". The command
: is "GRANT EXECUTE ON sys.dbms_sql TO ora_monitor".
: If i go back to login page and use SYS account then I receive message:
: "ORA-28009: connection to sys should be as sysdba or sysoper"
: but I cannot write "sys as sysdba" in the user field (invalid
: username/password). What should I do?

Mon Dec 17, 2001 9:58 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.