Learn more. Ask Question. Asked 2 years, 7 months ago. Active 2 years, 7 months ago. Viewed 1k times. Improve this question.
KS1 KS1 1 1 silver badge 8 8 bronze badges. Add a comment. Active Oldest Votes. On a Windows 95 Personal Oracle7 system, the count returned was 2. Connected as system to the same database with the DBA role enabled, the count was On a Windows NT system running Oracle 8.
From this exercise, you can learn two important points:. SQL file is Kbytes. SQL is Kbytes. In either version 7 or version 8, virtually every object defined in this script is either a view or a synonym.
In order to accomplish this, the kernel must have two specific pieces of information about the user: the username and the user id.
In addition, that information has to be available in the data dictionary tables. Since the username and user id are known from the login process, and since that data was verified against entries in the data dictionary, the kernel has the information available at all times to determine the levels of access that should be made available to each user.
If you want to apply the approach Oracle uses within the data dictionary code, you will need some method of associating the users with data in the application tables. More information on these scripts and their usage can be found at petefinnigan. There are many database diagramming tools that are not only incredibly useful but also free. After launching and connecting to SQL Server Management Studio, create a new login and select the database that is connected to Chartio. Download our free cloud data management ebook and learn how to manage your data stack and set up processes to get the most our of your data in your organization.
Setup A gist of a small subset of objects in the the Oracle database. Find all the children of SYS. Find all the parents of SYS. Sign up for free to join this conversation on GitHub. Already have an account?
Sign in to comment. You signed in with another tab or window. Reload to refresh your session.
0コメント