Create a new user-data control, Database Management System

Create a new user:

CREATE USER < user name > IDENTIFIED BY < Password>

Example: //CREATE USER MCA12 IDENTIFIED BY W123

Grant: It is used to give database access permission to users. It is of two types

(1)    system level permission

(2)    Object level permission.

 

Posted Date: 3/11/2013 1:15:59 AM | Location : United States







Related Discussions:- Create a new user-data control, Assignment Help, Ask Question on Create a new user-data control, Get Answer, Expert's Help, Create a new user-data control Discussions

Write discussion on Create a new user-data control
Your posts are moderated
Related Questions
1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

Give the reasons for allowing concurrency? The reasons for allowing concurrency is if the transactions run serially, a short transaction might have to wait for a preceding long

Describe the storage structure of indexed sequential files and their access method.  Ans:   Storage structure of Indexed Sequential files and their access: To achieve fast rand

Explain Alternate key? Alternate Key - All the candidate keys except primary key are known as alternate keys.

Determine the steps of path in association network You can analyse use of paths in association network in the following steps:  Examine every operation and see what asso

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

A step-wise distributed database design methodology Following is a step-wise methodology for distributed database design. (1) Examine the nature of distribution. Find out wh

What are the purpose for having variable length records? What kinds of separator characters are required for each? Variable-Length Records - Variable-length records are thos


explain exhaustively the problems associated with ER diagrams. include illustrations in your answer