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
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

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

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";

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: Sun Oct 23 07:15:36 CDT 2016

Total time taken to generate the page: 0.13770 seconds