Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
Add a reply View Replies (6)

Resolved Assigning User Privileges to Valentina Server through Valentina Studio

  1. Gaurav Joshi
    Gaurav Joshi
  2. Valentina Database ADK
  3. Monday, January 02 2023, 06:44 AM
  4.  Subscribe via email
Hello Everyone,
We have recently started using the Valentina Server and the Valentina Studio.
We wish to understand the following :
1. How to assign user privileges in Valentina Server through the Valentina Studio. I am able to find options to create / drop user or even change password, but unable to find any fields to select the user privileges ( SELECT, INSERT, UPDATE, DELETE, ADD ) through the Valentina Studio ( visually interface). Is it possible to do so through the Studio UI.
2. Is it possible to assign specific user privileges to a specific table in the DB. I understand that its possible to assign user privileges to the DB or Project, but I want to assign different privileges for the same user to different tables in the database.

Regards,
Gaurav
  1. ADK_V4RB_XOJO
Comment
There are no comments made yet.
Responses (6)
Sergey Pashkov
Sergey Pashkov Accepted Answer
Hello Gaurav,

1. Changing privileges is available only via SQL Editor for Server connection with SQL command (no specific UI).
2. According to the documentation, setting privileges for tables is not supported yet.

We'll discuss it, BUT I don't see any problem implementing it in the nearest versions.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
Scott
Scott Accepted Answer
I will second this request. Expanding user privileges at the table level would be very useful.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 2
Ivan Smahin
Ivan Smahin Accepted Answer
You may use following sql statement to see user privileges:



use master;

show grants;
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 3
Ruslan Zasukhin
Ruslan Zasukhin Accepted Answer
Hi Guys,

we have started git-branch with this task.
As only it will be finished we will produce a build with it.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 4
Ruslan Zasukhin
Ruslan Zasukhin Accepted Answer
Hi Gaurav,
Hi Scott,

Please notice the post about the 13b10 upload on this forum.

Below URL to the wiki page, which contains info about GRANT PRIVILEGES
References
  1. https://valentina-db.com/docs/dokuwiki/v13/doku.php?id=valentina:vcomponents:vsql:reference:grant_privileges#examples
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 5
Gaurav Joshi
Gaurav Joshi Accepted Answer
Hey Ruslan,

Thats really great.

You provided the feature so soon.

Really appreciate.

Regards,
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.