Entry

Database: MySql: PHPRunner: Security: How to set advanced security per username?

May 9th, 2005 08:55
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 08 May 2005 - 00:52 am ------------------------

Database: MySql: PHPRunner: Security: How to set advanced security per 
username?

---

Use the 'group permissions' in the step screen 'Security'.
Then you can assign rights to each individual user
present in a username password lookup table.

---

Steps: Overview:

 1. -Create a username+password table in
     MySql

--- cut here: begin --------------------------------------------------

CREATE TABLE `tableusernamepassword` (
 `primarykeyusernamepassword` int(11) NOT NULL auto_increment,
 `username` varchar(20) NOT NULL default '',
 `password` varchar(20) NOT NULL default '',
 PRIMARY KEY  (`primarykeyusernamepassword`)
)
ENGINE=InnoDB

--- cut here: end ----------------------------------------------------

 2. -Insert some usernames in this table

--- cut here: begin --------------------------------------------------

INSERT INTO `tableusernamepassword` VALUES ( 
1, 'admin', 'thepassword1' );
INSERT INTO `tableusernamepassword` VALUES ( 
2, 'someuser', 'thepassword2' );

--- cut here: end ----------------------------------------------------

 3. -Start PHPRunner

 4. -Start your project

 5. -Open the database in which you have stored this
     usernamepassword table

 6. -Press button 'Next' until
     you reach the step screen 'Security'

 7. -Enable radio button 'Username and password from database'

 8. -Click button 'Group permissions'

 9. -Click button 'Add group'

     1. -Choose an existing username from list

          e.g.

           admin

     -- or --

     1. -Choose to add a 'default' group

         (any user not explicitely in the existing
          username group, has only this specific
          default rights)

         1. -This will add the '<default>' entry
             to the list of existing usernames

10. -Choose the table options which
     this username or default group can perform

     1. -Add

     2. -Edit

     3. -Delete

     4. -List / View / Search

     5. -Export / Print

11. -Click button 'OK'

12. -Run your project

13. -Login with the username

      e.g.

       admin

14. -You will now see that this options are present
     or not (e.g. no print button for some user,
     and a print button for some other user, ...)

---
---

Internet: see also:

---

Database: MySql: PHPRunner: Link: Can you give an overview of links?
http://www.faqts.com/knowledge_base/view.phtml/aid/35950/fid/1805

----------------------------------------------------------------------