OraFAQ Forum: Server Administration » grant access to database

Home » RDBMS Server » Server Administration » grant access to database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

grant access to database [message #126411]

Mon, 04 July 2005 05:34

raghuraja_r
Messages: 22
Registered: February 2005
Location: chennai

Junior Member

hi

DCSEDB is the database that was created while installing oracle9i.

later i created a new database called ORACLEDB.

i logged in to sqlplus as sys/password@dcsedb and created a user called raghu.

now i want raghu to access the new database ORACLEDB. how to grant permission. please help me in this.

Report message to a moderator

Re: grant access to database [message #126419 is a reply to message #126411]

Mon, 04 July 2005 07:23

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

if there is more than one database in the same machine,
then
1. set ORACLE_SID.
sqlplus user/password will by default loginto your ORACLE_SID.
2. else
create a listener that can handle both the databases.
then you can access the databases like this.
sqlplus user/password@db1
sqlplus user/password@db2

Report message to a moderator

Re: grant access to database [message #126422 is a reply to message #126419]

Mon, 04 July 2005 07:39

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Hi mahesh,

I m a bit confused thats why i m messaging u. Is it possible that a user of one database can access another database provided both the databases are on the same machine. As i know the information of a user is stored in a database itself so how a user of one database would be able to access another ?

pls clear my confuseion.

Regards,
Tarun

Report message to a moderator

Re: grant access to database [message #126428 is a reply to message #126422]

Mon, 04 July 2005 08:06

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

HI Tarun

Ya I too got a bit confused with Mahesh's comments. Probably what he thought is that user had been created on machine & not on database.
Its the dblink that is the solution of this issue. Raghu needs to create a dblink from DCSEDB database to ORACLEDB database.

Regds
Girish

Report message to a moderator

Re: grant access to database [message #126477 is a reply to message #126411]

Tue, 05 July 2005 03:13

raghuraja_r
Messages: 22
Registered: February 2005
Location: chennai

Junior Member

Hi Friends
Thanks for all your replies.

As Tarun Sain how to create dblink.

and also i m confused wether the user is associated with dbase or dbase server. if it is associates with database how to provide access of the other database.

Thanks

Report message to a moderator

Re: grant access to database [message #126486 is a reply to message #126477]

Tue, 05 July 2005 04:10

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

HI

For creation process for dblink:
http://www-eleves-isia.cma.fr/documentation/OracleDoc/CREATE-DATABASE-LINK.html

Also, when u create a user in oracle using sql statement create user... its associated with oracle database only. Its not related to OS user.

Regds
Girish

Report message to a moderator

Re: grant access to database [message #126517 is a reply to message #126486]

Tue, 05 July 2005 06:14

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

My apologies.
I misunderstood and was addressing a completely different issue.
Dblink should be working in this case.

Report message to a moderator

Re: grant access to database [message #126607 is a reply to message #126486]

Tue, 05 July 2005 22:54

raghuraja_r
Messages: 22
Registered: February 2005
Location: chennai

Junior Member

Thanks Girish Rohini,

This is the syntax i was expecting i dont know how to ask for it an confused all our members. Thanks thanks thanks a lot.

and the link cleared my doubts in a simple maner. once again thanks a lot for all those who replied me.

Report message to a moderator

Previous Topic:	dedicated database server connections vs. globalization of sessions
Next Topic:	resize of datafile in system

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 15 16:46:14 CST 2025