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 / ravindra
Grant Create Session,Resource;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is the importance of a recovery model? : sql server DBA
how can you find out if a table can be redefined?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
what is the diffrence between core dba and apps dba?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are the recovery models for a database? : 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 would you do with an "in-doubt" distributed transaction?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
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.