August 13, 2003 at 6:23 am
Any ideas on how I can stop people from using their ID & Password that is used to access the 'system' to access the database via SQL system.
August 13, 2003 at 5:29 pm
Remove the "Windows User/Group" logins from SQL (Security/Logins node in EM). Careful you don't remove your own access.
Cheers,
- Mark
Cheers,
- Mark
August 14, 2003 at 12:16 am
quote:
Remove the "Windows User/Group" logins from SQL (Security/Logins node in EM). Careful you don't remove your own access.Cheers,
- Mark
The users has actually got another user-id that they use with read access via normal SQL, but now they are using there 'application' log-on to access SQL which mean that they can update as well.
August 14, 2003 at 1:12 am
My mistake. I thought you were talking about people using their Windows credentials.
You might be a candidate for using an Application Role. See "Establishing Application Security and Application Roles" in BOL.
(nb. BOL entry has been updated for SP3)
Cheers,
- Mark
Cheers,
- Mark
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply