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
Printable View
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
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.Quote:
Originally posted by Tarry
system is just a user with special privileges.
you can store yr data in the 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 .
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.Quote:
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.
I think he was to say "views".
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....Quote:
Originally posted by ronnie
Isnt SYS the owner of data dictionary tables and not system.
Quote:
Originally posted by jmodic
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....Quote:
Originally posted by ronnie
Isnt SYS the owner of data dictionary tables and 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