Re: [ADMIN] Limiting user privileges

[Bradley Kieser]

Or, the best way is to use views and not grant any priviledges on the 
table. The view must be created by the table owner and then grant 
priviledges on that view to a user. You can then create more than one 
view if you need, or else you can set up rules, triggers and procedures 
to implement what you want to implement.

This means, for exmample, that if you have a user table that contains 
the priviledges that a user might have, you can join in that table in 
the view using current_user to get to the row for the present user and 
set behaviour accordingly.

Bruno Wolff III wrote:
On Tue, Jan 11, 2005 at 14:26:15 -0600,
 Tad Marko <[EMAIL PROTECTED]> wrote:
 

I can
GRANT ALL ON a_specific_table TO user
but I can't figure out how to simply give some privilege to a user on
all tables.
   

You can't do it with a single GRANT statement. You need to write a script
or function to do it.
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
 

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly