|
|
|
|
|
|
| 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
|
|
|
|
|
|
| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
