@rakesh kumar Granting insert,update,delete,select on table x to user1 is more granular level security there are usually many application users with different levels of privileges accessing the same table x in a database. I could run grant select on table x to user2 ; this user will only have as the statements say ONLY select on tablex, Whereas the grant insert,update,delete,select on database db1 to user user1; Gives user1 the precedent privileges to all tables in database db1. To limit select ONLY to user2 I would run the below grant select on database db1 to user user2; Having said that database management is easier using roles otherwise management of user privileges can become a headache.
... View more
