Re: some problems

From: David <darussell_at_msn.com>
Date: Sun, 2 Aug 1998 01:30:54 +0100
Message-ID: <#aAT$yav9GA.91@upnetnews03>

SYS is the data dictionary owner.
SYSTEM is a special user defined by Oracle that is granted the DBA role and is used for some Oracle Specific tables. DBA role is a general role with most priviledges granted to administer the database.

DBA_ views are generally only made available to DBA's and provide a complete view of the dictionary.
ALL_ views are very similar to DBA_ views, do not provide a compilete view of the dictionary and be more suited to users.

Regards
David Russell

Manash Chakraborty wrote in message <6pspfa$ouo$1_at_earth.superlink.net>...
>What is the difference between user SYS and SYSTEM ?
>
>What are the restrictions DBA is having ?
>
>What are the differences between DBA_USERS and ALL_USERS ?
>
>Thanks in advance
> Tapash
>
Received on Sat Aug 01 1998 - 19:30:54 CDT