| grant select all tables/object of all schemas [message #289871] |
Wed, 26 December 2007 06:01  |
kamragulshan
Messages: 66
Registered: May 2005
Location: Delhi
|
Member |
|
|
Hi All,
I need to grant select rights on all the tables / object on all the schemas to a user say test.
This is our production database and we need to provide select rights on all the objects of all the schemas to a user for some development purpose.
Is there any way to provide such kind of rights.
Please provide me valuable input.
Thanks
Gulshan
|
|
|
|
|
|
| Re: grant select all tables/object of all schemas [message #289890 is a reply to message #289871] |
Wed, 26 December 2007 07:23  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
| Quote: |
This is our production database and we need to provide select rights on all the objects of all the schemas to a user for some development purpose.
|
Developing/testing on production system is surely one of the most dump thing I can imagine.
Of course everyone will know the password of this test user (I bet it is "test").
Why not just giving "select any table" to public?
Or better "DBA" then you will have no problem to access objects.
Regards
Michel
[Updated on: Wed, 26 December 2007 07:24] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
