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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
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 ?    7 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 ?    4 Yes 0 No
Trived.r
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How to Check Whether a Global Temporary Exists in a SQL Database or not?  2
How do we get month name in SQL Server 2000, Oracle, MS Access?  9
What are the two types of concurrency?  2
can you any body tell me the how to decrease the logfile  4
I have to display ten columns values from diffrent ten tables. how many joins are require? HCL8
what is the main difference between after trigger and instead trigger.  1
How can i change the column name. HCL7
create index a on employee(dno) In this,which index was created?  2
What is Report Server,Report Manager and Report Builder in SSRS 2005?  1
How can we write or define DDL statements in Sql server and DML statements?  2
If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?  1
What is referential integrity and how is it achieved? Adea-Solutions1
Can you have a nested transaction? HCL3
What is referential integrity? What are the advantages of it? Digital-Domain3
plz send every query in sql server2000 Infosys1
difference between sql server2000 and sql server2005 KPMG1
What is the difference between views and stored procedures? Can we have input parameters for views?  3
What are the types of backup and tell me the difference between full and differential backup? TCS3
Can we have more than one NULL in a column having unique constraint? 247Customer7
what is the diffrence between Snap Shot and Transaction Replication CSC1
 
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