Thursday, September 25, 2008

Re: [GENERAL] My first revoke

Hi, first of all, a new role doesn't have any privilege on any table (every type of database object has different default privileges), so you only have to grant select on the tables you want, and yes, one by one.

You can also grant or revoke privileges this way: grant select on table1,table2,table3...tableN to my_role;

No comments: