> By default tinyERP connect to database with the username of the unix > user. So if you specify "--db_user", it will use this username.
Thank you for the reply, ced. I discovered that switch at some point along the way but I'm still trying to determine WHICH user should start the tiny server. For instance, on my Linux box, if I start the tiny server as myself it starts and runs fine. If I try to use the tiny client to attach to the tiny server, I'm shown a database name in the login screen along with boxes for username and password with the username automatically filled in. However, I can't connect to the database that is displayed even though I started the server as myself and I'm using the client as myself. Obviously, during my many "experiments" with tiny, I've created a database as one user, somehow assigned permissions somewhere else, changed pgsql permissions and user permissions within the tiny client as admin, and so on. So the end result is a rather confusing mess :? What I wan't to do is start the tiny server as an unpriviledged user with no system login or home. If I'm understanding things correctly, I should be able to give that user dbcreate privileges within postgresql. I'm hoping this will allow a normal user, through the services of the tiny_server, to create and use terp databases. Access to various features and areas within each terp database would then be controlled by the admin (or admin user) for that specific database. Also, since whatever database is being used needs to be shared among several users on different computers on the local network I'm assuming that shared access is controlled by the tiny server rather than postgresql. As you can see, I'm fairly confused about the relationship between the various components and which one manages which access method and related permissions at any given time. I could spend hours on trial and error testing until I figured out what I need to know. However, it sure would be a lot faster and easier if someone already has the answers. And I'm with gegard on this. If someone can provide some pointers I'll be happy to create or contribute to a wiki document describing this part of the program. jacquita _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
