adspace


What number sorts of privileges are accessible in sql?

Answer Posted / Kaushal Kishor Meena

SQL provides several types of privileges, including SELECT, INSERT, UPDATE, DELETE, and ALTER. These privileges determine the level of access users have to specific tables or objects within a database.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1200


You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1216


How raid can influence database performance?

1119


List out the different types of locks available in sql server?

1051


Equi join and non equi join is possible with sql server?

1134


How to provide default values to function parameters?

1261


what is the difference between openrowset and openquery?

1197


Why use identity in sql server?

1203


What is a coalesce function?

1285


Can one drop a column from a table?

1091


Can you index views?

955


List the ways in which dynamic sql can be executed?

1088


Can sql servers link to other servers like oracle?

919


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1024


How efficient you are in oracle and SQL server?

1258