-
what privillege to grant?
we have a new employee who is a data modeler. He needs to see the stuctures of all the existing tables. As a DBA, how do you grant privile to him?
-
"create session" and "select any dictionary" should do it.
-
select any table you mean
-
only if he needs to see the data -- if it's just the structures then the dictionary priv should suffice.
-
"select any" (table or dictionary) will make the user see dba tables/views as well. Not a big problem but then you always come across users fresh out of a 3-day class and they ask you questions like "why is SQL*Net message received" waits are too high ??
svk
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|