Home » RDBMS Server » Server Administration » grant from db to another db
grant from db to another db [message #204131] Sat, 18 November 2006 01:04 Go to next message
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 Go to previous message
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
Previous Topic: question about 10g upgrades
Next Topic: Regarding dbms job
Goto Forum:
  


Current Time: Sat Dec 10 22:41:37 CST 2016

Total time taken to generate the page: 0.04166 seconds