New answers tagged

3

What is the best practice in managing users and roles? Create custom roles and grant permissions to the roles; then add users to the roles. eg: create role reader_abc grant select on dbo.a to reader_abc grant select on dbo.b to reader_abc grant select on dbo.c to reader_abc create role reader_ab grant select on dbo.a to reader_abc grant select on dbo.b ...


4

This behavior is noted in the "Remarks" section of the CREATE SCHEMA documentation, under "Implicit Schema and User Creation" (emphasis added to highlight what you are experiencing): In some cases a user can use a database without having a database user account (a database principal in the database). This can happen in the following situations: ...


0

Discovered what the problem was. sqlplus SYS/guardium111@XEPDB1 AS SYSDBA sqlplus paul/guardium111@XEPDB1 OR conn paul/guardium111@XEPDB1


0

adding up on my comment: you created a new user in server #1 - This user doesn't exist when creating a server #2 Why do you think you need another server - usually you want a new database-instance in server #1 for your new user CREATE DATABASE <newdb>; CREATE ROLE <db_user> WITH LOGIN NOSUPERUSER INHERIT CREATEDB NOCREATEROLE NOREPLICATION ...


2

Read the title of the documentation link you have given. "Create users in Azure Database for MySQL server". You're using MySQL syntax to try and create a user in Postgres. You'll be wanting to read this.


-1

I'm going thru this issue myself, so one easy thing you can do is change the password of asd. That can be done by running ALTER USER asd WITH PASSWORD 'new_password'; After that, I tried the following, which was provided by AWS Support and even took me a while to realize which commands should be executed by which role. -- logged in as postgres, grant the ...


0

To see all users, and when the password will expire: select user, password_expired, password_last_changed, password_lifetime, CASE WHEN password_lifetime IS NULL THEN 'Never' ELSE ADDDATE(password_last_changed,INTERVAL password_lifetime DAY) END AS password_expire_date from mysql.user u; To expire a password now (fur user 'jeffrey'@'...


2

This information, along with other user properties, is found in the user table in the mysql schema (database). The value 'Y' would indicate an expired password select password_expired from mysql.user where user = 'whatever'


1

MySQL 8.0 Reference Manual / ... / Setting Account Resource Limits (valid for 5.5+ at least). The server stores resource limits for an account in the user table row corresponding to the account. The max_questions, max_updates, and max_connections columns store the per-hour limits, and the max_user_connections column stores the MAX_USER_CONNECTIONS ...


4

It seems the user that you are trying to drop has played a role of grantor and hence you need to revoke those accesses before performing drop of user. Try running below command to get details of grantee first: select permission_name, state_desc, object_name(major_id) as securable,...


Top 50 recent answers are included