a question Consider the universal relation R= {A,

Download 1.99 Mb.

Page	2/5
Date	21.11.2021
Size	1.99 Mb.
	#57743

1 2 3 4 5

DBMS ASSIGNMENT 2

Syntax to grant privileges
Syntax to

Grant privileges:

To grant privileges to a user account, the GRANT statement is used.

Since using the Create User Statement only creates a new user but does not grant any privileges to the user account.

Syntax to grant privileges:

GRANT privileges_names ON object TO user;

Revoke Privileges:

The Revoke statement is used to revoke some or all of the privileges which have been granted to a user in the past.

Syntax to revoke privileges:

REVOKE privileges ON object FROM user;
Question 1

Discuss various types of cursors.

Cursors:

A cursor is a pointer to this context area. PL/SQL controls the context area through a cursor. A cursor holds the rows (one or more) returned by a SQL statement. The set of rows the cursor holds is referred to as the active set.

There are two types of cursors −

Download 1.99 Mb.

Share with your friends:

1 2 3 4 5