GRANT syntax for all object in the database?
Hello,
In MySQL the GRANT syntax allow to set priviledges for
all objects (e.g. tables) in the database, as follows:
GRANT SELECT ON database.* TO john;
Does IDS 11.5 SQL allow this syntax?
Thank You!
Reyna
_________________________________________________________
Reyna Sabina Phone: (305) 361-4324
NOAA/AOML/PHOD Fax: (305) 361-4392
14301 Rickenbacker Causeway Email: Reyna.Sabina@noaa.gov
Miami, FL 33149-1087
"Things do not get better by being left alone."
-Winston Churchill
No.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Tue, Sep 22, 2009 at 10:46 PM, Reyna.Sabina <Reyna.Sabina@noaa.gov>wrote:
> Hello,
>
> In MySQL the GRANT syntax allow to set priviledges for
> all objects (e.g. tables) in the database, as follows:
>
> GRANT SELECT ON database.* TO john;>
> Does IDS 11.5 SQL allow this syntax?
>
> Thank You!
> Reyna
> _________________________________________________________
> Reyna Sabina Phone: (305) 361-4324
> NOAA/AOML/PHOD Fax: (305) 361-4392
> 14301 Rickenbacker Causeway Email: Reyna.Sabina@noaa.gov
> Miami, FL 33149-1087
>
> "Things do not get better by being left alone."
>
> -Winston Churchill
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001517475742b088580474361833