Security Question- SQL DBA exparts, need your help...

Answer Posted / kiran

Always prefer giving permissions to a group.mark up the
permissions of a onto a group and then all u need to do is
add the new user to that group.this is the most efficient
way that new users can be added with same permissions as
that assigned to previous users.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of attribute relationships are there? : sql server analysis services, ssas

773


What is order of B+tree?

857


What are the disadvantages of using the stored procedures?

701


How to use wildcard characters in like operations in ms sql server?

804


How to find which stored procedure is currently running in sql server?

669






What is partition, how will you implement it? : sql server analysis services, ssas

795


What is a transaction and why is it important?

734


What is nolock?

745


How self join is different from outer join?

786


What are the types of subquery?

735


What are the security related catalog views? : sql server security

701


Is it possible for a stored procedure to call itself or recursive stored procedure?

719


Explain the flow of creating a cube? : sql server analysis services, ssas

797


What is the command to change the recovery model?

762


What are the types of table?

735