Announcement

Collapse
No announcement yet.

Seriously Off Topic but....

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Seriously Off Topic but....

    Have an issue with MYSQL and permissions.
    I have a datacenter that uses mysql and have given me a read only user account.
    Since I cannot modify his tables, what I have been doing is creating views and making datasets to report on from within my dev enviroment.
    I then send the views to the datacenter admin and he creates them for me.
    The issue is timing...
    Does anyone know if there is a way to give permissions to a user to just create and drop views only without giving permissions to create / drop the tables too?

    Kev

  • #2
    There is a Create View permission, I am not positive it will let you delete views also, but I suspect it will.
    Alan

    Comment


    • #3
      There's a GRANT CREATE VIEW statement so I guess it should be possible...
      Albert Drent
      aducom software netherlands
      scriptcase partner, reseller, support and (turn-key) development
      www.scriptcase.eu / www.scriptcase.nl

      Comment

      Working...
      X