<div>
Why do you say isn't working?<br />
What's the error?<br />
<br />
Anyway, you can't provide CREATE, DROP and INDEx. Those permissions are already part of the ALTER permission.<br />
Try the following:<br />

<pre><code id="code-20-42194062-1">USE JIRADB
GO
GRANT SELECT,INSERT,UPDATE,DELETE,ALTER TO test
GO</code></pre>
</div>


Why do you say isn't working?
What's the error?

Anyway, you can't provide CREATE, DROP and INDEx. Those permissions are already part of the ALTER permission.
Try the following:


USE JIRADB
GO
GRANT SELECT,INSERT,UPDATE,DELETE,ALTER TO test
GO

Jasmin shahrzad

<div>
<blockquote>
@Vitor: INDEX is a distinct privilege from ALTER
</blockquote>
I just realized that this question is MySQL related and not SQL Server. We don't have INDEX privileges in SQL Server.
</div>


> @Vitor: INDEX is a distinct privilege from ALTER

I just realized that this question is MySQL related and not SQL Server. We don't have INDEX privileges in SQL Server.

<div>
Jasmin, a feedback will be appreciated.<br />
Cheers
</div>


Jasmin, a feedback will be appreciated.
Cheers

<div>
Recommend closing with my comment 42194464.
</div>


Recommend closing with my comment 42194464.

<div>
Since comment 42194464 repeated 42194264, it probably should be split.
</div>


Since comment 42194464 repeated 42194264, it probably should be split.

<div>
<div class="content wysiwyg-content">
GRANT SELECT,INSERT,UPDATE,DELET<wbr />E,CREATE,D<wbr />ROP,ALTER,<wbr />INDEX on JIRADB.* TO 'test'@'jiratest&gt;' IDENTIFIED BY 'test';<br />
<br />
return<br />
<br />
Query OK, 0 rows affected (0,00 sec)
</div>
</div>


GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX on JIRADB.* TO 'test'@'jiratest>' IDENTIFIED BY 'test';

return

Query OK, 0 rows affected (0,00 sec)

why grant select on my sql not working?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.