Create role named roletable to allows a user to create table, Database Management System

Assignment Help:

Create role named role_table that allows a user to create tables. Using role_table allow users kripa and reena to create tables.

CREATE ROLE role_table;
GRANT CREATE ANY TABLE TO role_table;
GRANT role_table TO kripa, reena;

Related Discussions:- Create role named roletable to allows a user to create table

Domains, Every simple attribute of an entity type have a possible set of va...

Every simple attribute of an entity type have a possible set of values that can be attached to it. This is known as the domain of an attribute. An attribute cannot have a value out

Differentiate between primary and secondary storage, Differentiate between ...

Differentiate between Primary and secondary storage? Primary and secondary storage - Primary storage device stores the data temporarily. Primary storage is commonly used thro

Create table, What are the advantages of creating a table from existing tab...

What are the advantages of creating a table from existing table?

What is dml (data manipulation language)?, This language that enable user m...

This language that enable user manipulate to or access data as organized by appropriate data model. Low level or Procedural DML : DML needs a user to specify what data ar

Views, what is view?explain

what is view?explain

Define an operator that a relational algebra does not have, Define an opera...

Define an operator that a Relational Algebra does not have Ans: Relational Algebra does not have Aggregation operators.

What is conceptual schema, What is conceptual schema? The schemas at th...

What is conceptual schema? The schemas at the view level are known as subschema that describe dissimilar views of the database.

Main difference between read-only and update methods, What is the main diff...

What is the main difference between read-only and update methods? A read-only method does not affect the values of a variable in an object, whereas an update method may alter t

State the meaning of object representation, State the meaning of Object Rep...

State the meaning of Object Representation The term object representation means "to represent object with the help of objects model symbols". Implementing objects is too simp

Anomalies, define anomalies and different types of anomalies with example

define anomalies and different types of anomalies with example

Write Your Message!

Name

Email id

Message

Verfication Code

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages