| Database Account [message #11049] |
Wed, 03 March 2004 11:46  |
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  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
