SQL-SERVER GRANT UPDATE PERMISSION TO USER

علی ذوالفقار
1400/10/29 14:00:41 (215)
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
Back