Dave Page wrote:
Andy Shellam (Mailing Lists) wrote:
Andy Shellam (Mailing Lists) wrote:
A couple of niggly little issues with the roles in PgAdmin 1.6.2 on an 8.2.1 server.

When you click Login/Group Roles in the object explorer, you cannot right-click and do "new role" like you can with Databases and Tablespaces. Also the "New object of this type" button is not enabled when you click New group/login role - you have to add a new role by right-clicking the server connection, New Object... New Group/Login Role.

Any chance of having this sorted for the next release?

Thanks,


You also cannot drop a role from PgAdmin as all the Edit menu items are greyed out, except Properties.

All works for me. Are you sure the user you are logging in as has CREATEROLE privileges?

OK just discovered something weird... you're right in saying the user doesn't have 'create role' privelege, however, if I right-click the server connection, new object, new role, it works - and the role gets created within the server because I can use psql on the server to connect with the new role - only snag is once you've added the role in PgAdmin, you have to Refresh the login role list manually (right-click Refresh.)

Perhaps it's because I have super-user ticked for this user? If so, does that override the CREATE ROLE privelege?

I can send some screenshots showing the  process if needed.

Andy.


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to