Andrew, * Andrew Hall (andre...@hotmail.com) wrote: > 2. Non-default role -> a role which has to be explicitly activated during the > lifecycle of an application in order to gain access to database resources. > There are no limits on the number of non-default roles. This type of role > helps us to only provide a user with the minimal set of privileges that they > require at any given time, and minimise their access to database resources. > > I have looked through the PostgreSQL documentation, and cannot find anything > analogous to the 'non-default role' which I have outlined above - although > obviously it does support roles. > > I just want to confirm that all roles in postgreSQL are activated at login > time?
No. You need to read the documentation on the 'noinherit' attribute of roles. See: http://www.postgresql.org/docs/8.4/static/role-membership.html > Secondly, is there a limit on the number of roles which can be assigned to a > user (or more accurately a 'login role') in postgreSQL? No. Thanks, Stephen
signature.asc
Description: Digital signature
