OraFAQ Forum: Security » Non-schema owner default to schema

Home » RDBMS Server » Security » Non-schema owner default to schema

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

Non-schema owner default to schema [message #171137]

Mon, 08 May 2006 11:39

TLegend33
Messages: 203
Registered: March 2005

Senior Member

Is there a way to have a user default to always select objects from another schema the user has been granted access too?

For example, our code connects directly to objects within the schema owners schema 'user1'. We'd like to create another user 'user2' that can access the user1 schema for security purposes. I can currently select objects from user1 as user2:

select name from user1.name_table;

Is there any way I can select these same objects from user1 as user2 without having to preface the object with the user1 schema name?

user1.object_name

I ask because it would create a significant rewrite of our application.

Thanks.

Report message to a moderator

Re: Non-schema owner default to schema [message #171151 is a reply to message #171137]

Mon, 08 May 2006 13:30

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

Senior Member
Account Moderator

>>without having to preface the object with the user1 schema name?
You can use a synonym.
>>I ask because it would create a significant rewrite of our application.
Synonyms ***may*** create a significant drop in performance.
And for security purposes, username.object_name convention is better.

Report message to a moderator

Re: Non-schema owner default to schema [message #171158 is a reply to message #171151]

Mon, 08 May 2006 15:16

TLegend33
Messages: 203
Registered: March 2005

Senior Member

If the synonym is not created PUBLIC, how would security be comprimised? How is the data more secure using the username.object_name convention?

Thanks!

Report message to a moderator

Previous Topic:	how to do Privileges in oracle??? help me
Next Topic:	Transparent Data Encryption

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 20:09:34 CST 2024