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
The Database MySQL scripts cars_for_sale.sql and car_details.sql containing the data to use for this task have been supplied. To complete this task, you need to first create

The JOIN operation is applied on two relations. When we want to choose related tuples from two given relation join is used. The join operation need that both the joined relations m

Describe Application programming interface? Application Programming Interface - Commercial SQL implementations take one of the two primary techniques for involving SQL in a p

Explain the dependency relationship of object oriented A dependency is a relationship which states that a change in specification of one thing can affect another thing, but n


Differentiate between horizontal & mixed horizontal fragmentation?

Key to represent relationship amongs tables is called ? A Key that represent the relationship between tables is called Foreign Key.


What is the difference between internal tables and extract datasets? The lines of an internal table always have the similar structure. By using extract datasets, you can ha

Define the Query optimisation The query parser commonly generates a standard initial tree to correspond to an SQL query, with no doing any optimization. Such type of a canonica