How does one go about disabling a super user account within postgres without deleting it. I looked at the Alter Role documentation and I am drawing blanks. In addition this is the only super user account and the subordinate accounts own the tables that they are responsible for
I currently am installing Tomcat6 as a windows service that will be controlled by a user account that cannot login, nor is the account a member of any groups. The issue I am seeing is that the service will be installed, but the service stops after 20-30 seconds saying that it didn't have any work to do. UAC is disabled at installation time, and the installation is done by a user in the administrators group. How can I resolve this issue to ensure Tomcat properly starts up?
I have a test environment where there exist 2 roles:
group role with Superuser permissions (no login) and
user role that belongs to group.
When I trip the password to expire on this account I am unable to login again and therefore unable to change my password. How is the user to change their password once the valid until expires?
How does one go about explicitly denying the create function ability of a non superuser in postgres? I looked into the documentation, but was unable to find anything of value.
In the current environment there exists a policy where files within %system32% are only allowed to be owned by System and Administrators. An issue has arisen where after converting these permissions cmd.exe is unable to execute. The addition of the user that is currently logged in resolves this, however adding a group myGroup with the user contained fails. The command prompt informs me that I do not have the permissions which seems odd. Am I missing a registry edit or is there something else that I should be looking for here?
Currently I am experiencing an issue with a Postgres 8.3 install wherein after a system restart a service is unable. The error message is as follows:
waiting for server to start...Access is denied. ............................................................could not start server
The command being executed is
pg_ctl.exe start -N "MyService" -D "C:\MyData"
I am logged in and executing this as an administrator. The issue originally happened after uninstalling and reinstalling postgres, the /data directory was removed as well.