C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

Protect database in SqlServer2005

Posted Date: 12 Oct 2008 Total Responses: 5

Posted By: P.Renupriya Member Level: Silver Points: 1

How to protect the database from access by other users of the system( especially Administrator privileged ) from accessing the database
i.e
only the user who created the database should be able to access the database.

Responses

Author: Dharmaraj 12 Oct 2008

Member Level: Diamond

Rating:

Points: 1

Hi,
In Sql Server you can assign the users for the database.
Regards,
Dharma

Author: Vivek 12 Oct 2008

Member Level: Gold

Rating:

Points: 3

Refer

http://www.informit.com/articles/article.aspx?p=19712

http://www.sqlservercentral.com/articles/Security/sqlserversecurityfixeddatabaseroles/1231/

Author: Meetu Choudhary 12 Oct 2008

Member Level: Gold

Rating:

Points: 2

Assign the users of the database and it will solve your purpose

--
Thanks and Regards
Meetu Choudhary
-
please rate the post if it helps you

Author: @@@ Hyderabadi Biryani @@@ 14 Oct 2008

Member Level: Diamond

Rating:

Points: 3

Hi
Follow above suggestions and check out the below link

http://vyaskn.tripod.com/sql_server_security_best_practices.htm

Thanks -- Vj
http://dotnetvj.blogspot.com

Author: madhavi 25 Oct 2008

Member Level: Gold

Rating:

Points: 3

check out the below link

http://technet.microsoft.com/en-us/magazine/cc161026.aspx

http://www.bookmycourse.co.uk/course/maintaining_a_ms_sql_server_2005_database_30088/

Post Reply

You must Sign In to post a response.

	Next : sql server vs ms access
	Previous : What is CUBE in sql server?
	Return to Discussion Forum
	Post New Message
	Category: SQL Server

Related Messages

dotNet Slackers BizTalk Adaptors Web Design

conference call definitions