1. Gaurav Joshi
  2. Valentina Database ADK
  3. 月, 1月 02 2023, 06:44 AM
  4.  メールで購読
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.
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.
Scott 承諾済みの回答
I will second this request. Expanding user privileges at the table level would be very useful.
コメント
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.
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.
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.
Gaurav Joshi 承諾済みの回答
Hey Ruslan,

Thats really great.

You provided the feature so soon.

Really appreciate.

Regards,
コメント
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