x

Set Password on a database

I have created an app in C#, Sql server 2012. I Want to deploy a project On target machine and I want to set a password on only one database so that only those persons will have the direct access to the database in sql server who have the Password.How to perform this? any Help plz? Server is running in Windows Auth Mode

more ▼

asked Sep 29, 2014 at 10:02 AM in Default

avatar image

ikramonly
101 4 7 15

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

You don't secure it in that way. Since the server is in Windows Auth mode, you grant the user accounts access to the database based on their windows accounts. An alternative method would be to create an application auth system in the database. Each user then checks against a table in the database to ensure it has access. That is a .net membership exercise and will require you to rework a fair amount of your application. The easier solution is to rely on database permissions.

more ▼

answered Sep 30, 2014 at 01:53 AM

avatar image

CirqueDeSQLeil
5.5k 11 13 20

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x398
x131
x9

asked: Sep 29, 2014 at 10:02 AM

Seen: 541 times

Last Updated: Sep 30, 2014 at 01:53 AM

Copyright 2017 Redgate Software. Privacy Policy