How can we help you today? How can we help you today?

No prompt for grant statements?

I just tried typing in something like
grant execute on admin_TestCenter_update to

expecting that a list of users, roles, or both would appear, but neither happens. Is this by design?
monkeygrind
0

Comments

1 comment

Sort by
  • Tilman
    Hi,

    I'm afraid SQL Prompt 2 does not support the grant/revoke/deny statements.

    SQL Prompt 3 will be doing a slightly better job, in that users and roles will be on the list, but they wont necessarily be right at the top.

    We do intend to support these statements properly in the future. For the moment, we are concentrating on getting the DML statements right, though.

    Regards,

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.