OraFAQ Forum: Server Administration » ! Shared a View for users but they cant see that view

Home » RDBMS Server » Server Administration » ! Shared a View for users but they cant see that view

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

! Shared a View for users but they cant see that view [message #63849]

Tue, 16 November 2004 19:06

nvtnow
Messages: 5
Registered: April 2004

Junior Member

i shared a view for other users but they cant select that view. I Applied so that they could select that view. Can anybody explain that problem?? thanks.

Report message to a moderator

Re: ! Shared a View for users but they cant see that view [message #63861 is a reply to message #63849]

Wed, 17 November 2004 18:41

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

I don't quite understand your problem, but have you
granted SELECT access to those users?

GRANT select ON my_view TO that_user;

Best regards.

Frank

Report message to a moderator

Re: ! Shared a View for users but they cant see that view [message #63864 is a reply to message #63861]

Wed, 17 November 2004 20:42

nvtnow
Messages: 5
Registered: April 2004

Junior Member

i did it! But users still coundn't read that view.

Report message to a moderator

Re: ! Shared a View for users but they cant see that view [message #63870 is a reply to message #63849]

Thu, 18 November 2004 03:03

Balaji
Messages: 102
Registered: October 2000

Senior Member

hi ,

after u create the view the user cant find it because he does not have select for objects in ur schema .so the dba must give the other user the system privilege like this

SQL> grant select any table to kkk ;

now kkk will be able to select this view like this

SQL> select * from vic.myview ;

hope tghis works.

balaji

Report message to a moderator

Re: ! Shared a View for users but they cant see that view [message #63877 is a reply to message #63870]

Fri, 19 November 2004 00:15

Frank
Messages: 7901
Registered: March 2000

Senior Member

Select any table is WAY over the top !
grant select on vic.myview to kkk should do it.

Report message to a moderator

Re: ! Shared a View for users but they cant see that view [message #63882 is a reply to message #63864]

Sat, 20 November 2004 02:05

Frank
Messages: 7901
Registered: March 2000

Senior Member

Did you create a synonym ?
Either:
create public synonym [[view_name]] for [[owner of view]].[[view_name]] to create 1 public synonym that everybody can use.
or:
as user that wants to select from the view:
create synonym [[view_name]] for [[owner of view]].[[view_name]] to create a private synonym, only usable by and visible to the user that creates this synonym
or:
select ... from [[owner of view]].[[view_name]]
instead of
select ... from [[view_name]]

Besides this you still need the grants.

hth

Report message to a moderator

Previous Topic:	RELEASE 8.1.7.4 ISSUE
Next Topic:	Doubts on redo log files.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 06:18:45 CDT 2024