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 2021 - 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
----------------------------------------------------------------------