On 01/02/07 18:24 +0100, jacquita wrote: > > > > 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 >
The db user of the server is used to determine which databases can be connected. And after, when you choose a database, this is the user login that determine your right on tinyERP Cédric Krier
pgpM8JE4H41qX.pgp
Description: PGP signature
_______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
