Home » RDBMS Server » Security » Database Account
Database Account [message #11049] Wed, 03 March 2004 11:46 Go to next message
Priyanka Shah
Messages: 19
Registered: January 2003
Junior Member
I am executing sql query using one database account and the there is another procedure I want to use another account.. since all standard procedures are in that account...

I doono why the procedures are kept in a seperate account in production... any ideas?

I am using java and I will have to create connection object twice for this so I was wondering...

Do you need to have procedures in one account?

Can I just create an account which can do both ? What are the advantages & disadvantages?
Re: Database Account [message #11050 is a reply to message #11049] Wed, 03 March 2004 12:38 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
The user that owns those procedures can grant an execute privilege on one or more of those procs to the user account you are currently using. This would allow you to just keep using the one account.
Re: Database Account [message #11056 is a reply to message #11049] Wed, 03 March 2004 20:13 Go to previous message
Jitendra Agrawal
Messages: 71
Registered: December 2003

Just grant execute priviledge to the other user.

Jitendra Agrawal.
Previous Topic: issue with fine grain policies
Next Topic: Simple encryption for tables (XOR or something like that)
Goto Forum:

Current Time: Thu May 26 15:58:40 CDT 2022