| grant from db to another db [message #204131] |
Sat, 18 November 2006 01:04  |
selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai
|
Senior Member |
|
|
Hi friends,
I have created one username and password in xyz database,
i have granted DBA ,connect and resources to myusername.
I want to access another database, name is like abc.
how to grant abc to xyz myuser name......?
Thanx in advance
Thanx and Regards
Selva.R
|
|
|
|
| Re: grant from db to another db [message #204133 is a reply to message #204131] |
Sat, 18 November 2006 01:14  |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
hi
how to grant abc to xyz myuser name......?
YOu cann't. why bcoz abc is DB name is not role , prevs..
you have to use DBlinks option..
you can create database link for ABC database and assess another database...
like this
create database link "link_name"
connect to "user_name"
identified by "pwd"
using "another_dbname_you_want_to_connect";
test...
SQL>select * from dual@"db_link_name".
hope this helps
Mohammad Taj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
