I think it is right---the superuser can select from
the view, even if the view's owner tries to prevent that---,
but maybe a good way is checking owner's privilage when creating a view as
Oracle.
It would be better not to create a view if a user cann`t access a table.
regards, hx.li
rrent object is view1) should have the select privilage for
table tb2. I dno't usderstant why do it so?
regards, hx.li
"Tom Lane" дÈëÏûÏ¢ÐÂÎÅ:7536.1256911...@sss.pgh.pa.us...
> No, that would be a bad idea. Your proposal essentially means that it's
> impossible for a supe
quot;select * from
view1".
Maybe I have a misconception for superuser?
regards, hx.li
- Original Message -
From: "Tom Lane"
Newsgroups: pgsql.bugs
Sent: Thursday, October 29, 2009 9:34 PM
Subject: Re: [BUGS] BUG #5147: DBA can not access view
> "Dongni" wri
