how to use the mask valuesin sql SP

• rams.prsk

  Ten Centuries

  Points: 1241

  More actions

  September 30, 2011 at 8:25 pm

  #244753

  Hi All,

  Iam having users table with mask values 1--to view the only first page of the application, 2--view 2nd page..16--have admin rights ..etc

  Could anyone provide me the sql query where i can give the rights to the users based n the mask values :

  eg: 1. Suppose if i want to provide access rights to a user for first and second pages only....

  2. What if i want to provide the admin rights to the user

  Please send me the sql query

  Thanks a lot:)

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  September 30, 2011 at 11:25 pm

  #1389081

  Before I take the time to write this query, I'd like to see what you have done so far to solve this problem.