[RESOLVED] bit pattern to maintain the privileges

[vidz]

Need a big help i need php/mysql script or tutorial how to maintain privileges(access tables using binary representation) to access tables or records.
eg admin needs to acess all branch tables. but branch managers need to access only his branch tables.

[Bonesnap]

Are you talking about restricting access on a database level or an application level? On a database level you should take a look at the grant statement of MySQL. It's generally a good idea to create multiple users with varied access to your project (and never connect as root). You can restrict access right down to individual columns.

[vivek151189]

you can read some document about the role base action it is the thing that you need

[vidz]

Thanku guys for replying
@
application level access

@
Thanks buddy i have googled & found what i want.

This is a good tutorial
http://www.xaprb.com/blog/2006/08/16/how-to-build-role-based-access-control-in-sql/