.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

Set permission for SQL login id

Posted By: Jayabharathi     Posted Date: September 21, 2008    Points:2   Category :Sql Server
In sql i want to set the permission , tht others r not allowed to access my database.
I set login id for tht, but if they login in other database (in SQL query analyzer) thn they hav the option to change the database in the dropdown in sql query analyzer .
So i want to stop that.

if they try to access my database, then i want to display "U hav no permission to access this".

Author: Amit Mehra             
Posted Date: September 21, 2008     Points: 5   

I guess you are using SQL Srver 2000 if yes then open "Enterprise Manager" Select your Database ->Security->Logins->Righr click on the user->Properties->Database Access Tab->Select the Database you want to give permission for the user.

Please "Mark As Answer " if this post help you.
Author: Jayabharathi             
Posted Date: September 21, 2008     Points: 5   

Thank for ur help.
but stil i hav some doubts.

during the login creation itself i selected tht database.
After that i select db_owner and try to unchecked tht public option in database roles grid(second one in database access tab ) it shows message like "members cannot be dropped from public ".

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend