Creating A User Account And Access To View

[dangerousYo]

Hi there:

I am managing a database, in which i want to create an user account and give him/her an access to certain part of certain tables in the database. I did create a view but i didnot know to how to link the select statements with the view with the user account?

Could anyone explain to me the steps to do that in SQLyog?

thanks in advance

[peterlaursen]

to grant privileges for VIEWS in a single database (or a single view only)

tools menu .. user manager .. manage permissions

select the database and define privileges by checking SELECT (and whatever) for the databse itself in the uppermost window or for specific view(s) in window no. 2 from above

tools menu .. user manager .. add/edit user is for defining user name, password and GLOBAL privileges

tools menu .. user manager .. manage permissions is for defining OBJECT SPECIFIC privileges

so if you want only OBJECT SPECIFIC privileges for this user, nothing shall be checked in add/edit user!

Attached image shows a TABLE 'notes' and a VIEW 'notesview' in the 'test' database. SELECT privilege for the selected user is defined on 'notesview' but not on 'notes' and not on any other tables or views either!

[dangerousYo]

Thank you for your reply, but i do need further help.

I managed to create the view in the database, and add a test user 'test@%'. Now when i go to manage permissions, and choose the user, and check the database that i created the view in, i don't see the view in the list of tables. i only see it in the information_schema (which i honestly don't what it means)

All i am trying to do is to give a user an access to the View in that database from outside the network.

thank you in advance

[peterlaursen]

“…and check the database that i created the view in, i don't see the view in the list of tables”

You should absolutely see the VIEW itself in the database where it belongs! (and if you do not understand Information_Schema then keep your hands off it!)

What is the SQLyog version you are using? Is it recent? Please try a recent version if you don't!

[Author]

Posts