totalo commented on pull request #9987: URL: https://github.com/apache/shardingsphere/pull/9987#issuecomment-816665288
> Hi @totalo , > > I know the privilege system of SQLServer is large and complicated, but we can firstly fill some necessary privileges of `Server level`, `DB` and `table`. > > [principals-database-engine](https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/principals-database-engine?view=sql-server-ver15) and[Guide to SQL Server Permissions](https://blog.netwrix.com/2020/10/16/guide-to-sql-server-permissions/) give us a brief introduction on SQLserver's privileges. We can learn that there are two layers of principals, i.e., `Server-level` and `Database-level`. > > I assume that > > * `Server-level` privileges is bound to be mapped to our `AdministrativePrivileges` and `DatabasePrivileges` > * `DB-lever` privileges belong to `globalPrivileges` of `DatabasePrivileges` or `specificPrivileges` > * Still we have table some privileges putting into `TablePrivileges` > > Also, there are many different specific privileges on `server-level` and `db-lever`, right? You can pick up the main ones as the first step. > > This is just my opinion, welcome your any reply. Yes, I think so too. I have already looked at principals-database-engine when searching for information. But at the time, my grasp of the direction was not very clear. Thank you for providing me with these three directions, please give me some time, I will study it, and then revise this PR. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected]
