New answers tagged

0

I had same issue on 8.0.21 NDB Cluster. I was looking at the error log and trying to figure out what is wrong, and I saw this NDB: Query 'CREATE USER IF NOT EXISTS 'admin'@'localhost'' failed, error: 1819: Your password does not satisfy the current policy requirements NDB: Query 'REVOKE ALL ON *.* FROM 'admin'@'localhost'' failed, error: 1269: Can't revoke ...


1

You can use the built-in database role db_datareader EXEC sp_addrolemember N'db_datareader', N'<MYUSER>' or you can create your own database role USER <MYDB> CREATE ROLE [<MYROLE>] GRANT SELECT ON SCHEMA::[dbo] TO <MYROLE> EXEC sp_addrolemember N'<MYROLE>', N'<MYUSER>'


0

You should run Redis as an administrator to avoid this issue.


0

The MySQL 5.7 GRANT Syntax Documentation says something interesting about wildcards Under the subheading Object Quoting Guidelines, Paragraph 1 says: Several objects within GRANT statements are subject to quoting, although quoting is optional in many cases: Account, database, table, column, and routine names. For example, if a user_name or host_name value ...


-1

you need to use skip special characters \ in your command GRANT SELECT ON 'DBname'.'foo\_%' TO 'username'@'%' IDENTIFIED BY 'password';


0

Per the knowledge base, SELECT privileges on mysql.proc is sufficient.


0

When non sysadmins execute the SP everything works except for adding users to the database roles with error: Cannot alter the role 'db_datareader', because it does not exist or you do not have permission. According to the ALTER ROLE documentation: Additionally, to change the membership in a fixed database role you need: Membership in the db_owner fixed ...


0

It is only supported in mysql 8 https://dev.mysql.com/doc/refman/8.0/en/roles.html


1

One thing you could try is to create stored procedure that would select from a View When creating stored procedure, use EXECUTE AS clause and set it to a Windows-authenticated account (grant all necessary permissions to this account, required to read from I:\Folder) Grant execute on procedure to SBA_USER This way when SBA_USER executes procedure, procedure ...


1

Can anyone confirm why this is required and what it's function is within the SQL Engine This privilege when granted to user account will give ability to the account to adjust maximum memory that other process can use. See the official document This privilege determines who can change the maximum memory that can be consumed by a process. This privilege is ...


Top 50 recent answers are included