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