SQL-SERVER Grant Permission to user

علی ذوالفقار
1399/04/25 18:42:33 (741)
grant create table to db_user
grant create view to db_user
grant drop table to db_user
grant drop view to db_user

grant select to db_user
grant insert to db_user
grant delete to db_user
grant update to db_user

full command : 
GRANT #PERMISSION# ON OBJECT::[dbo].[#TABLE_NAME#] TO [#USER_NAME#]
GRANT SELECT ON OBJECT::[dbo].[TBL_USERS] TO [DBUSER_1]
Back