SQL-SERVER GRANT UPDATE PERMISSION TO USER
علی ذوالفقار
1400/10/29 14:00:41 (475)
GRANT PERMISSION ON TABLE LEVEL :
GRANT SELECT , INSERT , UPDATE , DELETE
ON OBJECT::[DBO].[TABLE_NAME] TO [USERNAME] ;
DENY SELECT , INSERT , UPDATE , DELETE
ON OBJECT::[DBO].[TABLE_NAME] TO [USERNAME] CASCADE ;
GRANT PERMISSION ON FIELD LEVEL :
GRANT UPDATE([FIELD_NAME]) ON OBJECT::[DBO].[TABLE_NAME] TO [USERNAME]
DENEY UPDATE([FIELD_NAME]) ON OBJECT::[DBO].[TABLE_NAME] TO [USERNAME] CASCADE