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
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
how does an oracle clusterware manage crs resources?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What are the steps you will take to improve performance of a poor performing query?
What is dbcc? : sql server DBA
What is a system database and what is a user database? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
what do you understand by flashback feature of oracle?
What are the different types of upgrades that can be performed in sql server? : 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?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
what functionality does oracle provide to secure sensitive information?
What is dcl? : sql server DBA