December 27, 2012 at 9:24 pm
We need to allow are client to have access on the views only and nothing else regarding create ,delete,update of database,table,stored procedures ,restore and backup etc.
I create a new user and restricted using grant and deny permissions but .....their are number of default user that can access the database and a windows authenticated user.
I didn't got any thing to restrict it ....Can i delete those user which are :
NT SERVICE\MSSQL$SERVEREXPRESS
domian/user
NT SERVICE\MSSQL$SERVEREXPRESS
BUILTIN\Users
##MS_PolicyTsqlExecutionLogin##
##MS_PolicyEventProcessingLogin##
any suggestions ?
December 28, 2012 at 1:05 am
maida_rh (12/27/2012)
I didn't got any thing to restrict it ....Can i delete those user which are :NT SERVICE\MSSQL$SERVEREXPRESS
domian/user
NT SERVICE\MSSQL$SERVEREXPRESS
BUILTIN\Users
##MS_PolicyTsqlExecutionLogin##
##MS_PolicyEventProcessingLogin##
any suggestions ?
NO .. these are system genrated and required credantials . these are mandatory.
See in your case the only things you can do is
1) revoke the permission on those other users wherever possible
2) educate the people to use only recommended one.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply