Re: Select privilage on all the tables in a schema.

On Apr 25, 9:02 pm, Gladiator <vkamalnath1...@[EMAIL PROTECTED]
> wrote:
> Any Suggestions on the below scenario will be helpful to us.
>
> # There are 10 tables in a schema =93S1=94 and  I have to give select
> privilege (Only read access) to a user on all the tables in the schema
> =93S1=94.
>
> # Initially I have given the required privileges to the user with
> grant command on every table..
>
> #  But the problem here is whenever there are new tables building in
> the schema =93S1=94, We have to give the privilege Explicitly.
>
> # It is okay if we have less number of tables and  the changes are not
> frequent, But our case is the tables are changing and there are
> hundreds  of it.
>
> # Is there any way we to automate whenever a new table is created in
> that schema the select privilege should go to user .
>
> Thanks
> -Kamal.

AFAIK it is not possible (but it would be great if someone proved me
wrong :-). I solved the problem with a script that loops over all the
tables in a given schema and grant select on each one to a user

/Lennart