Re: User Level Access Control Priviledges

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, 12 Aug 2004 17:50:44 -0400, trystano@xxxxxxx <trystano@xxxxxxx> wrote:
> I meant be implemeting the User Access priviledges into the database, so then the code being used will extract that this data for certain users and execute whats necessary.
> 
> For example...
> 
> CREATE TABLE User (
>   ID int not null
> , Name varchar(30) not null
> , PRIMARY KEY (ID)
> );
> 
> CREATE TABLE AccessObject (
>   ID int not null
> , Description varchar(255) not null
> , PRIMARY KEY (ID)
> );
> 
> CREATE TABLE UserAccessPermission (
>   User int not null
> , AccessObject int not null
> , CanRead char(1) not null default('Y')
> , CanWrite char(1) not null default('N')
> , PRIMARY KEY (User, AccessObject)
> );
> 
> Hope this helps you grasp what I had in mind.
> 

LiveUser does this.

-- 
DB_DataObject_FormBuilder - The database at your fingertips
http://pear.php.net/package/DB_DataObject_FormBuilder

paperCrane --Justin Patrin--

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux