OraFAQ Forum: Server Administration » create public synonyms prob.... or just DBA problem?

Home » RDBMS Server » Server Administration » create public synonyms prob.... or just DBA problem?

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

create public synonyms prob.... or just DBA problem? [message #50959]

Tue, 16 April 2002 09:36

Anthony
Messages: 48
Registered: September 2000

Member

Hi all, I don�t know if this is in the right area but anyway.

I am working in database where using my role I have created some new tables, I then created some synonyms for these tables to another role. The idea is that this user can only see these specific tables and nothing else.

I managed to get priviledges from the DBA to create synonyms to this other role, but when I log on using this new role I can�t see any of the tables I have created.

I used the create public synonym blah blah
and then create synonym for (new user).table from (my_role).table but no joy seeing the tables

Is the DBA forgetting to do something? (this is a real possibility as the DBAs here are ...well you know!)

Report message to a moderator

Re: create public synonyms prob.... or just DBA problem? [message #50960 is a reply to message #50959]

Tue, 16 April 2002 09:48

Mike
Messages: 417
Registered: September 1998

Senior Member

Hi,

did the owner of these tables grant select on his table to this new user?
If not do so

Hope that helps
Mike

Report message to a moderator

Previous Topic:	Re: ocp . - dumps,braindumps,kits,cbt,tbt,sts......
Next Topic:	Re: Bitwise AND in oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 07:02:15 CST 2024