0
sql>select * from user_tab_privs;
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
When should you create a role in Oracle?
I think role is for these two purposes. 1>to grant a group of related privileges to a user 2>to simplify the process of granting and revoking privileges
Where can online users find Metalink Oracle support?
Online users can find Metalink Oracle support from DOAG, as well as the main Oracle support community. These options allow a user to ask questions through a forum, and have answers given to them by technical support.
Where can one find help for user provisioning?
One can find help for user provisioning software through a number of IT companies. One can find help from companies such as IBM, Microsoft, Oracle, Solaris and Linux.
What option must a user have to grand another user privileges on an object not owner by the user?
admin option
How do you undo a GRANT in Oracle?
Use the Oracle revoke command Example: revoke execute on procedure from user;
What windows 7 design improvement allows applications that require administrative privileges to run even when the user running the application does not have administrative privileges?
User account control settings.
Where can one learn about sorting an IT asset inventory?
When looking to find further information in order to learn about sorting an IT asses inventory then it might be possible to view the Oracle assets user guide that is available from the Docs Oracle website.
Why must create user in oracle todo your work in oracle?
A user in Oracle corresponds to a schema. Objects, such as table and indexes, must exist within a schema. Without creating a user/schema, use of the database will be limited to the built-in schemas and objects, such as the one-row DUAL table and standard PL/SQL packages.
Where can I find an Oracle database certificate program?
You can find an oracle database cirtification program from the education.oracle.com website. There you will also find other educational resources for oracle.
How you remove a table in oracle?
via sql one can remove an oracle table (if one has the appropriate privileges) using the drop table tablenamesyntax,or, if one wishes to 'empty' a table, usetruncate table tablename
Where can one find oracle interview questions?
One can find oracle interview questions at the Oracle site. Other sites one can find Oracle interview questions are the Glass Door site as well as the Indiabix site.
Which command is used to assign rights and privileges to users?
chown user filename
