Don,
Yes, I am able to create user(s) in that database. We fixed that problem
with these grants. Please confirm is the right way to do it.
*GRANT ALL PRIVILEGES ON rangerdb.* TO 'rangeradmindb'@'localhost' WITH
GRANT OPTION;*
* GRANT ALL PRIVILEGES ON rangerdb.* TO 'rangeradmindb'@'%' WITH
GRANT OPTION;*
* GRANT ALL PRIVILEGES ON rangerdb.* TO 'rangeradmindb’@'FQDN'
WITH GRANT OPTION;*
*GRANT ALL PRIVILEGES ON rangerdb_audit.* TO 'rangeradmindb'@'%' WITH
GRANT OPTION;*
* GRANT ALL PRIVILEGES ON rangerdb_audit.* TO
'rangeradmindb'@'localhost' WITH GRANT OPTION;*
* GRANT INSERT ON rangerdb_audit.xa_access_audit TO
'rangerloggerdb'@'FQDN';*
*GRANT INSERT ON rangerdb_audit.xa_access_audit TO
'rangerloggerdb'@'localhost'*
On Wed, Jan 4, 2017 at 12:08 PM Don Bosco Durai <bo...@apache.org> wrote:
> Also, Anandha, were you able to create any other user in your database? If
> so, what was the syntax and DB user you used?
>
>
>
> Thanks
>
>
>
> Bosco
>
>
>
>
>
> *From: *Pradeep Agrawal <pradeep.agra...@freestoneinfotech.com>
> *Reply-To: *<user@ranger.incubator.apache.org>
> *Date: *Tuesday, January 3, 2017 at 7:27 PM
> *To: *<user@ranger.incubator.apache.org>
> *Subject: *Re: Ranger database setup in AWS Aurora database.
>
>
>
> Hi,
>
>
>
> For that, you need to refer Aurora DB docs provided by amazon.
>
>
>
> For MySQL please refer below text.
>
>
>
> *MySQL/MariaDB Prerequisite :*
>
> Server variable *log_bin_trust_function_creators *should be set to 1.
>
> MySQL Server variable in RDS can be changed by Parameter group feature
> provided in RDS Dashboard at the left side of the page.
>
> For details please refer
>
> · https://www.stratalux.com/blog/always-use-custom-db-
> parameter-group-creating-rds-instance/
>
> · http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/
> USER_WorkingWithParamGroups.html
>
> - https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
>
> On Wed, Jan 4, 2017 at 8:07 AM, Anandha L Ranganathan <
> analog.s...@gmail.com> wrote:
>
> I am using "Aurora" database in AWS. Aurora is MySQL compatible RDBMS
> database.
>
> I am unable to grant privileges to the user "rangeradmindb".
>
> 1. CREATE USER 'rangeradmindb'@'localhost' IDENTIFIED BY 'xxxxx';
>
> 2. GRANT ALL PRIVILEGES ON *.* TO 'rangeradmindb'@'localhost';
>
> 3. Error Code: 1045. Access denied for user 'dbm'@'%' (using password: YES)
> 0.034 sec
>
> 4.
>
> Whereas superuser has these privileges.
>
> 1. show grants
>
> 2. GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS,
> REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK
> TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW
> VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER
>
> How do I grant all privileges to the the user "rangeradmindb"
>
>
