SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY
PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT
PRIVILIZES.
Answer Posted / suman
we have to create any user in system level By default we
have 8 prives that is
create table
create index
create sysnonims
create view
etc......
sys>desc v$session_prives;
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Which autogrowth database setting is good? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
Explain materialized views and how they are used.
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What is the importance of a recovery model? : sql server DBA
What is dbcc? : sql server DBA
when does an alert gets signaled?
what functionality does oracle provide to secure sensitive information?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
which background process invoke at the time of upgradation tell me???
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
how can you get actual data change values from previous transactions in oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Can you redefine a table online?