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
- 8019 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
Why does Oracle not permit the use of PCTUSED with indexes?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What are the different sql server versions you have worked on? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
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
Query processing is slow(eg select query)how will u solve that
how can you find out if a table can be redefined?
What would you do with an "in-doubt" distributed transaction?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
How would you best determine why your MVIEW couldn't FAST REFRESH?
what is logical system in sap basis
What is the default fill factor value? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
