← Back to Posts

SQL-SERVER Grant Permission to user

👤 علی ذوالفقار 📅 1399/04/25 18:42:33 👁️ 927 views
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 to Posts