1. Gaurav Joshi
  2. Valentina Database ADK
  3. Понедельник, Январь 02 2023, 06:44 AM
  4.  Подписаться через 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
Комментарий
There are no comments made yet.
Gaurav Joshi Ответ принят
Hey Ruslan,

Thats really great.

You provided the feature so soon.

Really appreciate.

Regards,
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
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
Ссылки
  1. https://valentina-db.com/docs/dokuwiki/v13/doku.php?id=valentina:vcomponents:vsql:reference:grant_privileges#examples
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
Hi Guys,

we have started git-branch with this task.
As only it will be finished we will produce a build with it.
Комментарий
There are no comments made yet.
Ivan Smahin Ответ принят
You may use following sql statement to see user privileges:


use master;
show grants;
Комментарий
There are no comments made yet.
Scott Ответ принят
I will second this request. Expanding user privileges at the table level would be very useful.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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.
Комментарий
There are no comments made yet.
  • Страница :
  • 1


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories