SYS user and RECYCLEBIN/DROP [message #376297] |
Tue, 16 December 2008 18:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
greendba
Messages: 22 Registered: September 2008 Location: Toronto
|
Junior Member |
|
|
This question is a toss up between general admin and recovery...
Why is it that the SYS user cannot access SHOW RECYCLEBIN the same way as every other user?
What if the sys user creates a table and drops it... We cannot use "flashback table table_name before drop" How do we recover the table?
Thanks!
Eric
|
|
|
|
|
Re: SYS user and RECYCLEBIN/DROP [message #376509 is a reply to message #376297] |
Wed, 17 December 2008 11:31 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
greendba
Messages: 22 Registered: September 2008 Location: Toronto
|
Junior Member |
|
|
Thanks for the input gentlemen(peoples of all gender?)...
I understand the functionality of SYS... but the rational for why certain features don't function the same way as regular users, I don't...
My thinking is in Linux terms... the root user should never be used except for administrative tasks... however, the root user can create documents and do other "normal" user tasks...
I guess this quotes sits best with me
"...SYS schema is not supposed to be used for any custom object. It is meant only for metadata..."
Thanks to both you for your input
Cheers!
|
|
|
Re: SYS user and RECYCLEBIN/DROP [message #376582 is a reply to message #376509] |
Wed, 17 December 2008 23:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | I understand the functionality of SYS... but the rational for why certain features don't function the same way as regular users, I don't...
|
Quote: | - SYS is special
- SYS does not act like any other user
- When you use SYS Oracle deactivates some code path and activates others
|
You just have to admit this, SYS is NOT a regular user.
Quote: | My thinking is in Linux terms... the root user should never be used except for administrative tasks... however, the root user can create documents and do other "normal" user tasks...
|
Any analogy has its limits then this is one SYS is not root, it is just for administrative tasks.
I should say that Unix is wrong, root should not be able to act like any other user.
SYS is not a superuser, it is from outer user space. (Like PUBLIC is not a role.)
Regards
Michel
|
|
|