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
how can you get actual data change values from previous transactions in oracle?
Why would you use sql agent? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
how can you record information about current session?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
internal architecture
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
What is the default fill factor value? : sql server DBA
what is the role of dip user in our database?
how can you communicate with operating system files from oracle?