SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY
PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT
PRIVILIZES.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / feroz
creating user at OS level wont get any privileges
question is not clear first of all?
how come a DBA will be able to create a user
we cann't create users at DB2 level
Is This Answer Correct ? | 0 Yes | 6 No |
Explain what partitioning is and what its benefit is.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what is logical system in sap basis
what is the use of recording information about current session?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Can you redefine a table online?
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.
Is it possible to update the multiple field values in a single query? If possible then write the actual query.
how can a session indicate its interest in receiving alerts?
Hi This is request to DBA man Q. I have installed Oracle 10g Express edition in Linux fedora Core 6.When i have run the following script for ORACLE _HOME environment variable setting . script is ". /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" variable is set but it is working only in current session. If i restart the system again i should run that script. So haw to set permanently ? even i have try with export command for that environment set it also does not work. Q. When i run sqlplus in shell prompt It is working but when i give user name and password the following error come out i.e # sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 2 19:45:40 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: system Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory I have also proper partition of disk means swap memory are available. # fdisk -l Disk /dev/sda: 40.0 GB, 40060403712 bytes 255 heads, 63 sectors/track, 4870 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 1275 10241406 7 HPFS/NTFS /dev/sda2 1276 4870 28876837+ f W95 Ext'd (LBA) /dev/sda5 1276 3187 15358108+ 7 HPFS/NTFS /dev/sda6 3188 4672 11928231 83 Linux /dev/sda7 4673 4863 1534176 82 Linux swap / Solaris
What happens on checkpoint? : sql server DBA
Explain about your sql server dba experience? : sql server DBA