| Insuff Privs for a View [message #2242] |
Mon, 01 July 2002 11:14  |
Chris
Messages: 128
Registered: November 1998
|
Senior Member |
|
|
|
I know this sounds simple, but I am stuck... There is a table TABLEA. It has public select but no grant option. The owner of TABLEA has created a view VIEWA that displays most of the data in TABLEA. Some users can see the view, some cannot. Since the grant option is turned off on the table, granting a priv is not the solution. Any help would be appreciated.
|
|
|
|
|
|
| Re: Insuff Privs for a View [message #2257 is a reply to message #2242] |
Tue, 02 July 2002 08:01  |
Chris Hagood
Messages: 2
Registered: July 2002
|
Junior Member |
|
|
I am the owner of the view. Becuase the base table the view references has the GRANTABLE option set to 'NO', I cannot grant privs on the view. One solution is to have the owner of the table change the GRANTABLE option, but I was hoping to find another solution. Thanks for your reply!
--Chris
|
|
|
|
|
|
| Re: Insuff Privs for a View [message #2262 is a reply to message #2242] |
Tue, 02 July 2002 11:12 |
Chris Hagood
Messages: 2
Registered: July 2002
|
Junior Member |
|
|
I am the owner of the view. Becuase the base table the view references has the GRANTABLE option set to 'NO', I cannot grant privs on the view. One solution is to have the owner of the table change the GRANTABLE option, but I was hoping to find another solution. Thanks for your reply!
--Chris
BTW... I am using version 8.1.5
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
