Multiple user database design
        Posted  
        
            by 
                dieguitoweb
            
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by dieguitoweb
        
        
        
        Published on 2011-02-07T15:21:48Z
        Indexed on 
            2011/02/07
            15:25 UTC
        
        
        Read the original article
        Hit count: 254
        
I have to develop a basic social network for an academic purpose; but I need some tips for the users management..
The users are subdivided into 3 groups with different privilege: admins,analysts and standards users. For every user should be stored into the database the following information: name,lastname,e-mail,age,password.
I'm not quite sure how I should design the database between theese two solutions:
1)one table called 'users' with the 'role' attribute that explain what a user can do and what can't do, and the permissions are managed via php
2)every application user is a database user created with the query 'CREATE ROLE' (It's a postgres database) and he has permissions on some tables granted with the 'GRANT' statement
You should take into account that the project is for a database exam..
thanks
© Stack Overflow or respective owner