I am pursuing my engineering first year and interested towards database technologies.
New to sql server and please help me out with the security related t-sql . I tried to blog security related quires but there is no particular blog which has all security related quires
Can anyone point me to a blog where all security related quires available? i.e right from adding logins to providing server level , database level, table level,coloumn level permissions e.t.c
I even require a script to check out the permissions assigned to the login on server and database level like permissions assigned to user on stored proc, table e.t.c
Sql server version: 2008