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

Advantages and disadvantages of using a database system, What are the advan...

What are the advantages and disadvantages of using a database system. Sol. Advantages of Database System (DBMS) : (1) Data Redundancy and Inconsistency: Since differen

Decompose the table with the functional dependencies, Decompose the table w...

Decompose the table with the following description and functional dependencies into a set of equivalent tables normalized to 3NF or BCNF. This database stores records from a (ve

Participation constraints, The participation Constraints shows whether the ...

The participation Constraints shows whether the existence of an entity depends on its being associated to another entity by the relationship type. There are two kinds of participat

What are the failures of controlling events between objects, What are the f...

What are the failures of Controlling Events Between Objects Failure Unintentional termination of system. Several possible causes: failure of system hardware, o

Development of an ER diagram and database implementation, i want answers th...

i want answers this assignment now if yiu can maket for me now ?

The second normal form (2nf), The Second Normal Form (2NF) Definition: ...

The Second Normal Form (2NF) Definition: A relation is in 2NF if it is in 1NF and each non-key attribute is fully dependent on each candidate key of the relation. Some of th

Concurrency control, Give the two reasons for allowing concurrency

Give the two reasons for allowing concurrency

Lock, lock and types of lock

lock and types of lock

What is trigger, What is trigger? Triggers are statements that are exe...

What is trigger? Triggers are statements that are executed automatically by the system as the side effect of a modification to the database.

What are called journaling file systems, What are called journaling file sy...

What are called journaling file systems? File systems that support log disks are known as journaling file systems.

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