Mega Code Archive

 

Categories / MSSQL Tutorial / User Role

 

Check user id with user_id() function

4> IF ( SELECT id  FROM sysobjects  WHERE id=OBJECT_ID('foo') 5>     AND uid=USER_ID() AND type='U') > 0 6>     DROP TABLE foo 7>