Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > IBM DB2 > Select privilag...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 8831 of 9130
Post > Topic >>

Select privilage on all the tables in a schema.

by Gladiator <vkamalnath1237@[EMAIL PROTECTED] > Apr 25, 2008 at 12:02 PM

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.
 




 4 Posts in Topic:
Select privilage on all the tables in a schema.
Gladiator <vkamalnath1  2008-04-25 12:02:13 
Re: Select privilage on all the tables in a schema.
Lennart <Erik.Lennart.  2008-04-25 21:58:57 
Re: Select privilage on all the tables in a schema.
Knut Stolze <stolze@[E  2008-04-28 20:04:52 
Re: Select privilage on all the tables in a schema.
agrkanhaiya@[EMAIL PROTEC  2008-06-14 00:27:16 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 3:09:02 CDT 2008.