ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
What are three SQL keywords used to change or set someone?s
permissions?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What are three SQL keywords used to change or set someone?s permissions?
Answer
# 1		 
grant,revoke and third no ideaa
 
Is This Answer Correct ?    0 Yes 0 No
Deepti
 
  Re: What are three SQL keywords used to change or set someone?s permissions?
Answer
# 2		 
The three SQL keywords are grant ,revoke and deny.
 
Is This Answer Correct ?    0 Yes 0 No
Shraddha
 
 
 
  Re: What are three SQL keywords used to change or set someone?s permissions?
Answer
# 3		 
this used to changes the permissions on database
this DCL(DATA CONTROL LANGUGE)STATEMENT

*)GRANT---THIS IS ACCESS GARANTED ON PARTICLUR DB OR 
                                        USER
*)DENY----THIS IS PARTICLUR USER WAITING FOR ACCESS WHILE
          TME WHEN COMMETED THE DATA THEN PERMISSION ON DB
                          
*)REVOKE--- THIS STATEMENT USE THE USER HAVE NO PERMISIONS
 
Is This Answer Correct ?    0 Yes 0 No
Trived.r
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no. iFlex2
What's the maximum size of a row?  4
how to retrive only second row from table in sql server 2000? CTS7
how to get the rowid/rownumbes of a table in sqlserver IBM1
can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?  1
What's the purpose of Stored Procedure? Wipro3
Define candidate key, alternate key, composite key.  5
What are user defined datatypes and when you should go for them?  1
How to find the date and time of last updated table?  2
What is the difference between IN and EXISTS operators in SQL Server? Intelligroup2
What should we do to copy the tables, schema and views from one SQL Server to another?  3
What is Query Execution Plan? How does it help optimize or tune a database driven application? Accenture1
create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error? IBM1
explain different types of jions with examples briefly? Zensar2
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table? eFunds4
About Indexed Views? with example? plz reply...  1
How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all) McAfee3
How to find the date and time of last updated table? Teledata1
When you first load SQL SERVER you will startup with what all databases? CompuSol2
what is web server? Satyam3
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com