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
What is schema

User error :  This contains errors in the program (e.g., Logical errors) with errors made by online users of database.  These types of errors can be avoided by applying some check

Explain about database system structure? Storage manager Authorization and integrity manager Transaction manager File manager Buffer manager Storage manager

List two restrictions that are applied on the modification (updation, insertion or deletion) of base tables through view.  Ans: The two restrictions are: 1. If a view

Primary Key The primary key is the candidate key that is selected by the database designer as the principal denotes of identifying entities within an entity set. The left candi

What are the DBMS languages? Briefly explain? Data Definition language (DDL):A database schema is specified through a set of definitions expressed through a special language

File Organisation In Dbms Introduction Databases are used to store information. Usually, the principal operations we have to perform on database are those relating to:

What are the Constituents of File? Also elaborates all the possible file operations? A file is organised logically as sequence of record. These records are mapped onto disk blo

what is object-identity

Benefits of Sequential File Organisation It is quick and efficient when dealing with huge volumes of data that require being processed periodically (batch system). Dra