Interested to Buy Any Domain ? << Click Here >> for more details...
SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY
PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT
PRIVILIZES.
- 4 Answers
- 8186 Views
- Cognizant, I also Faced
- E-Mail Answers
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
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Explain about your sql server dba experience? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
How do you open a cluster administrator? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Where would you look for errors from the database engine?
what is a crs resource?
What types of replication are supported in sql server? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What are the commands used in dcl? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are statistics, under what circumstances they go out of date, how do you update them?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
