This content has been marked as final. Show 6 replies
semsem wrote:check this
hi all, db and dev 10g rel2
, how to make a user sees another user objects , what is the priviliges i should pass to him to do the task ,
i want scott user to see the hr objects and do anything on it , insert,update,delete , create and drop anything ,...........?
thanks in advance
Hope this helps
Creating Tables in another schema:
the same works with procedures etc.
granting privileges on objects:
as you can see this is all well documented, please go through the documentation yourself instead asking us to abstract it for you.
And just for the record: create any table is a very powerful privilege to grant to a user; I'd think twice or more often about if you really need that.