Display(Permission) one table/view to a new user in MySQL

For the one table permission to view data, follow the below process: 

1) Create the MySQL User 

CREATE USER 'USERNAME'@'USER_IP/HOST_NAME';

2) Execute the permission query to view only single table/view data

GRANT SELECT ON database.table / view to 'username'@'USER_IP/HOST_NAME' identified by 'password';

Wildfly server.log prevent to application log separate

If you want to log the information in separate files configure in log4j.properties

<subsystem xmlns="urn:jboss:domain:logging:6.0">
<add-logging-api-dependencies value="false"/>
<use-deployment-logging-config value="false"/>
....
</subsystem>

If you want to log the information in server.log for all application in deployment directory

<subsystem xmlns="urn:jboss:domain:logging:6.0">
<add-logging-api-dependencies value="true"/>
<use-deployment-logging-config value="false"/>
....
</subsystem>


Add these lines inside of <subsystem xmlns="urn:jboss:domain:logging:6.0">  tag.

Note : logging:6.0 is version number, So it could be 1.0/2.0/3.0/4.0 etc.