-
Hi,
Should the user System be attached to the System table space or is it advisable to attach it to some other.
Please suggest.
Also whats the difference between sys and system.
I know sys is the super user but what is system.
Thanks
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
system is just a user with special privileges.
you can store yr data in the system tablespace.
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
Originally posted by Tarry
system is just a user with special privileges.
you can store yr data in the system tablespace.
Yes, you can, but it is better to make it's default tablespace another than system tablespace.
Cheers
Angel
-
By default, system is the user who has the right to access sys objects. It is wise to set system user on other tbs rather than the system tablespace.
Susan
-
what are the special priveleges that the user sys has .
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
WEll to start with he's the owner of the data dictionary tables.
So all the base tables and data dictn views are are stored in his schema SYS.
Besides alterations to the storage parameters oracle advises the KEEP OFF option for this user.
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
Originally posted by Tarry
WEll to start with he's the owner of the data dictionary tables.
So all the base tables and data dictn views are are stored in his schema SYS.
Besides alterations to the storage parameters oracle advises the KEEP OFF option for this user.
Isnt SYS the owner of data dictionary tables and not system.
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
I think he was to say "views".
ovidius over!
-
Originally posted by ronnie
Isnt SYS the owner of data dictionary tables and not system.
Sure he is! And this is exactly what Tarry was saying. You've asked about SYS user and Tarry's response was about SYS, not SYSTEM....
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Originally posted by jmodic
Originally posted by ronnie
Isnt SYS the owner of data dictionary tables and not system.
Sure he is! And this is exactly what Tarry was saying. You've asked about SYS user and Tarry's response was about SYS, not SYSTEM....
Oops,
Now I know what happenned.
I wanted to ask what special priveleges does the user system has and based on that question i was reading the response.
Sorry about that
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
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
|