| Author |
Topic |
|
issammansour
Yak Posting Veteran
51 Posts |
 Posted - 2007-09-25 : 15:57:42
|
| Hi,How to set a database security like set a password, is there any security for S.P. to disable view to the sp for any view or modifications.Best Regards |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-25 : 16:00:14
|
You can use sp_password (2000) or ALTER LOGIN (2005) to change passwords. quote:
is there any security for S.P. to disable view to the sp for any view or modifications
I don't understand your question.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
issammansour
Yak Posting Veteran
51 Posts |
Posted - 2007-09-25 : 16:05:39
|
| to have a password for the database view, what i mean when i click on the database to view to ask about my user name and password |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-25 : 16:07:34
|
| That is not possible in SQL Server. You get prompted for credentials when you connect to the server, not when you access an object.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
issammansour
Yak Posting Veteran
51 Posts |
Posted - 2007-09-25 : 16:11:01
|
| is there any tool form other party can do this |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-25 : 16:12:56
|
| Why don't you just lock down security so that this isn't required?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
issammansour
Yak Posting Veteran
51 Posts |
Posted - 2007-09-25 : 16:22:02
|
| how to do this |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-25 : 16:23:06
|
| Well what access do the users have? What access is needed from the application? Are you the DBA for the system? Are there other sysadmins that you are trying to prevent looking at the database?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-25 : 22:16:31
|
| You can encrypt sp and view with encryption option. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-25 : 23:02:04
|
quote:
Originally posted by rmiao
You can encrypt sp and view with encryption option.
This just encrypts the text, he would still need to lock down the security permissions like Tara said.
Future guru in the making. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-25 : 23:40:51
|
| Original question has two issues, I addressed the other one. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-26 : 05:55:39
|
| Can I just clarify what Tara said, in case it helps.You setup a user, lets call them UserA, so that when they login to the database they have permissions to use certain things.You COULD set up the permissions so that the ONLY thing UserA has permission to use is that one view.Note that this is overly simplistic, and you need to set up more fully thought through security roles etc., but it might just help with the basic concepts.Kristen |
|
|
|
|
DataBase Security