What might be nice is a deductive syntax, so you can GRANT ALL and then
remove privileges for certain objects:
GRANT ALL ON DATABASE foo TO user EXCEPT...
> It is perhaps interesting to do something like
> GRANT SELECT ON TABLE foo.* TO user;
> but I'm not sure this is so useful as to be wor
Sam Barnett-Cormack <[EMAIL PROTECTED]> writes:
> GRANT out to have a varying degree of granularity, IMO. So you can
> specify individual sequences or tables, a glob (handy for
> table+sequence), possibly an intelligent way of including anything
> requisite for a given table, a whole DB, a whole na
On Mon, 26 Jul 2004, Jean-Luc Lachance wrote:
> I have been thinking about this problem for quite a while.
>
> Proper administration require creation of groups.
> Adding a new user to a database is as simple as adding the user to the
> group that has the required privileges to the database.
>
> Bu
I have been thinking about this problem for quite a while.
Proper administration require creation of groups.
Adding a new user to a database is as simple as adding the user to the
group that has the required privileges to the database.
But, I think one new command would be very usefull.
CREATE GR
On Mon, 26 Jul 2004, Randall Perry wrote:
> Thanks, I'll use it.
>
> But, if the developer's are listening -- this is really obtuse. MySQL
> administration is much easier. Please consider simplifying the GRANT process
> for future revs.
I do agree with this, actually - in fact, let me expand.
GR
Thanks, I'll use it.
But, if the developer's are listening -- this is really obtuse. MySQL
administration is much easier. Please consider simplifying the GRANT process
for future revs.
BTW, I prefer postgresql for all my own development.
on 7/18/04 4:41 PM, Oliver Elphick at [EMAIL PROTECTED] w
On Sun, 2004-07-18 at 20:52, Randall Perry wrote:
> This is a pain. Couldn't we gave something simple like
> GRANT ALL ON database.* TO JOE;
>
> Which would grant full access to all objects in the database to JOE for all
> time?
You can do it like this in psql:
\a
\t
\o /tmp/grant.sql
SELECT
This is a pain. Couldn't we gave something simple like
GRANT ALL ON database.* TO JOE;
Which would grant full access to all objects in the database to JOE for all
time?
> Ulrich Meis wrote:
>> 1. Write a script that queries the postgres internal tables for all
>> tables,schemas,sequences,views,fu
Ulrich Meis wrote:
> 1. Write a script that queries the postgres internal tables for all
> tables,schemas,sequences,views,functions,... and then executes grant
> statements for each one of them. This would have to repeated each
> time a new object is created.
Yes, that's the most popular method so
