SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Re : ORA-01031 Error

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Re : ORA-01031 Error
Author Message
Guest






Post Re : ORA-01031 Error Reply with quote

: To avoid reinstalling things, try granting SESSION and RESOURCE privileges to
: DB_AUDIT user. I think this will fix the problem.

Hi,
I executed the following commands:

grant resource to "DB_AUDIT";
grant create session to "DB_AUDIT";

However, I still get the error.
Can you please help?

Thanks,
Liana

Fri Dec 01, 2006 2:52 pm
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: Re : ORA-01031 Error Reply with quote

Does DB_AUDIT user have EXECUTE permissions for DBMS_JOB, DBMS_SQL, DBMS_OUTPUT, UTL_FILE packages?
Does it have DELETE and SELECT for SYS.AUD$?

: Hi,
: I executed the following commands: grant resource to "DB_AUDIT";
: grant create session to "DB_AUDIT";

: However, I still get the error.
: Can you please help?

: Thanks,
: Liana

Fri Dec 01, 2006 3:00 pm View user's profile Send private message
Guest






Post Re: Re : ORA-01031 Error Reply with quote

Yes, DB_AUDIT user does have all the privileges you specify,
but I still get the ORA-01031 error.
Any other suggestions?

Liana

: Does DB_AUDIT user have EXECUTE permissions for DBMS_JOB, DBMS_SQL,
: DBMS_OUTPUT, UTL_FILE packages?
: Does it have DELETE and SELECT for SYS.AUD$?

Mon Dec 04, 2006 1:29 pm
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.