| Access to another schema [message #188964] |
Tue, 22 August 2006 10:35  |
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
|
Senior Member |
|
|
Is it possible to give access to the user to another schema ?
The user should have the complete access to the schema. Can this be done ?
|
|
|
|
|
|
| Re: Access to another schema [message #189987 is a reply to message #188994] |
Mon, 28 August 2006 23:03  |
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
|
Senior Member |
|
|
Thanks for the reply.
But I have more than 100 tables in the schema. It will be bit difficult to grant access to each and every table. Is there any way that we can give access using a single command or a stored procedure?
|
|
|
|
| Re: Access to another schema [message #190091 is a reply to message #189987] |
Tue, 29 August 2006 04:47 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
There is way to do this.
You have to create script which is very easy....
You have to create spool file with .sql extension.
connect as user on whose object we have to give complete access to other user
run below script
Select 'grant select on' ||Tname|| ' to <username who need access>;' from tab ;
e.g Select 'grant select on' ||Tname|| 'to scott;' from tab;
you will get result of above query in .sql (extension) spool file, now run this spool file.
Now connect with the user to whom you want to give access... to check that user got access or not..
cheers..!
sunilkumar
[Updated on: Tue, 29 August 2006 05:07] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
