OraFAQ Forum: Server Utilities » How to let sys user to have access right to another user's resource?

Home » RDBMS Server » Server Utilities » How to let sys user to have access right to another user's resource?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to let sys user to have access right to another user's resource? [message #69043]

Thu, 18 October 2001 06:55

Simon
Messages: 60
Registered: December 1998

Member

Hey,

Thank you guys for your help. Right now I have another problem. I create another user named ECOMMERCE using the SYS account, and then set the default tablespace of this ECOMMERCE account as USER. Now I can use that account, but how can I let SYS user still have right to access all the tables or other resources of user ECOMMERCE? Thank you in advance.

Simon

----------------------------------------------------------------------

Report message to a moderator

Re: How to let sys user to have access right to another user's resource? [message #69069 is a reply to message #69043]

Tue, 23 October 2001 11:58

Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida

Senior Member

'sys' is a VERY powerful id. sys should be able to see the 'ecommerce' schema. Hint - fully qualify the tables, like ecommerce.table_a ...

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	Help:use svrmgrl,but error.
Next Topic:	Script for compiling all packages

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 23:08:25 CDT 2024