Need answer regarding DB users managament

Hello everyone!

I am practicing for some exam and I have this Q/A.

The most efficient way for setting up rights for some DB users is:

a) Set up rights for existing users

b) Create new user and set up his rights

c) Create new account and set up his rights

d) Create new group and set up its rights


I would appreciate any help.

Thanks!

 

This is more of a common sense answer.

A. Setup many accounts and their rights
B. Create many accounts and their rights
C. Doesn't even make sense, because then you still setup their permissions and have changed nothing.
D. Setup one group and its rights and assign users to it.

You never mentioned if these were existing users.

 

I just wrote the question as it is. Maybe it has general meaning...

 

I would still go with D unless its a few users and nobody will ever be adding anyone else to those same permissions.

 

Thanks a lot. As you said... I would go for D with common sense, too.