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
Explain current page table and shadow page table. The key idea behind the shadow paging method is to maintain two page tables during the life of the transaction: the current pa

Home based assignment Consider an ORDER table with the following attributes: • Order Number (ONo),Customer Number (CNo),Customer Name (CNa),Item Number (INo),Unit Price (UP), Quant

Determine the language that needs a user to specify the data to be retrieved with no specifying exactly how to get it is Ans: Non-Procedural DML

Evaluate, compare and contrast the two methods of relational database design namely top down method and Bottom up method. What will be your choice if you are asked to select a meth

What is data independence? Data Independence: Techniques which permit data to be changed without affecting the applications in which procedure it. There are two types of data

What is OLAP? OnLine Analytical Processing (OLAP) is a Business Intelligence (BI) reporting system. OLAP gives the user with the capability to sum, count, average and do other

What is serializability? Explain its types? The data base system must control concurrent implementation of transactions, to ensure that the data base state remains consistent.

1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development

Explain the Role of a database administrator a. Defining the Schema   The DBA describes the schema which consists of the structure of the data in the application. The DBA

Describe analysis of access paths To describe analysis of access paths, consider an example of the design of a company's employee skills database. A part of the object model fr