I am in a mysql terminal and I created a user. I tried to grant the user privileges with And got the error: So I tried And got So I am trying to grant privileges to a user but I am stuck. Answer Try this: Make sure the password used for the user complies with the password policy
Tag: privileges
Can’t access to schema in postgres
Lets say that I made this “simple” implementation of a DB in Postgres postgres=# CREATE ROLE my_role; CREATE DATABASE my_db; GRANT ALL ON DATABASE my_db TO my_role; …
How to revoke MySQL user privileges for one table?
When I have granted privileges to a user for some specific tables: How do I revoke the privileges for this user, just for table1? Answer Google is your friend! http://dev.mysql.com/doc/refman/5.7/en/revoke.html Syntax: To further explain this answer – I’ll teach how to fish (rather than just give you a fish). The MySQL documentation can look confusing at first – the “syntax”
How to know if a user has a privilege on Object?
I would like to know if a user has a privilege on an object or not. I’m working on SQL Developer. When I query manually the table DBA_TAB_PRIVS, I get all the information needed. However, I need this information to be used in some triggers and functions. So, I’m writing PL/SQL function that will return 1 if a role has
Display default access privileges for relations, sequences and functions in Postgres
After altering the default privileges on a Postgres database object, how can you view them? For instance, if you grant all privileges to role_name for all tables created in the schema schema_name: Answer Using a SQL query Where the value of defaclobjtype is r = relation (table, view), S = sequence, f = function. These access privileges are only for