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 8 privilizes that is
create index
create views
create synonyms
create tables
create procedures
create triggers
create functions
we can see in db level that is
> desc v$session_privilizes;
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What authentication modes does sql server support? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
how can you initialize log miner?
Which autogrowth database setting is good? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What the different types of replication and why are they used? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
what do you understand by flashback feature of oracle?
What is dbcc? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
how can you communicate with operating system files from oracle?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
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