Quote:
|
Originally Posted by sqlguru
Can you give an example of this (or a link)?
|
Quick SQL Server example
Code:
/*
2 = can edit posts
4 = can move posts
8 = can delete posts
16 = can ban users
*/
DECLARE @permissions int
DECLARE @edit_posts bit
, @move_posts bit
, @delete_posts bit
, @ban_users bit
SET @edit_posts = 0
SET @move_posts = 1
SET @delete_posts = 0
SET @ban_users = 1
SET @permissions = Power(2 * @edit_posts , 1)
+ Power(2 * @move_posts , 2)
+ Power(2 * @delete_posts, 3)
+ Power(2 * @ban_users , 4)
PRINT @permissions
IF 2 & @permissions = 2 PRINT 'Can Edit Posts'
IF 4 & @permissions = 4 PRINT 'Can Move Posts'
IF 8 & @permissions = 8 PRINT 'Can Delete Posts'
IF 16 & @permissions = 16 PRINT 'Can Ban Users'