Unsupported Screen Size: The viewport size is too small for the theme to render properly.

grant to Users?

forums › forums › SQLyog › Using SQLyog › grant to Users?

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • April 11, 2003 at 2:52 pm #7831
      mk123
      Member

      Some of my hosting Clients are asking for access to their database from Webyog, what Grant should i give so that they do the normal jobs and restricted to their databases only.

      I'd be nice if you give the Grant statement 🙂

    • April 11, 2003 at 3:01 pm #14052
      CalEvans
      Member

      grant all on databasename.* to user@host identified by 'password'

      Obligatory link to the manual page that should be consulted before asking questions that have already been answered in the manual.

      HTH,

      =C=

    • April 11, 2003 at 3:59 pm #14053
      Ritesh
      Member

      Why do people confuse SQLyog with Webyog?

      Webyog is the company name and SQLyog the product…..

      Anyway, great to know that people are using SQLyog 😀

    • April 11, 2003 at 4:26 pm #14054
      mk123
      Member

      well have to do someone's else job as the main person is away so you can think of a newbie here. 😛

      What i was concerned about the grant all….

      Instead of grant all what specific grants we can give for normal users?

      Thanks in advance.

    • April 11, 2003 at 7:03 pm #14055
      Ritesh
      Member
      Quote:
      Instead of grant all what specific grants we can give for normal users?

      You can provide specific permissions like Select, Update, Insert, Delete, Create, Drop, Grant, References, Index, Alter for a DB to a user 😀

      HTH

  • Author
    Posts
Viewing 4 reply threads
  • You must be logged in to reply to this topic.