New answers tagged security
SQL Server never automatically disables any account. Only a human intervention can do that.... Probably you could put a request for your DBA to provide error logs for the timings you wanted....and you could find the info from the logs....
I found a solution involving a few extra steps. The "tenant_admin" role is still created the same way, but it is now used as follow: postgres=> SET ROLE tenant_admin; SET postgres=> CREATE ROLE "owner3"; CREATE ROLE postgres=> GRANT ...
Grant the necessary permissions on the database RidaDatabase to the user PLESK01\IWAM_plesk
When the O7_DICTIONARY_ACCESSIBILITY parameter is set to false, users with SELECT ANY TABLE privilege can not access tables such as SYS.USER$, unless they have direct privileges to them.
Switch to PostgreSQL. It allows for stored procedures in many languages, which can validate input before issuing the SQL commands. The user can be given rights to the stored procedure without any other access.
By using the listed script, the user cannot give himself server level create db rights. My next step would look to see if it's possible someone else with sysadmin or high-level permissions did that for him because they misunderstood permissions.
Top 50 recent answers are included