Thread: Issues with roles
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, -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world"
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.
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? Regards, Dave.
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.
Andy Shellam (Mailing Lists) wrote: > 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. No thanks - I got it. Patch applied to SVN. Thanks, Dave.