spring-projects / spring-projects/spring-security
ACL Microsoft SQL Server schema docs
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 9.6k
- Forks
- 6.3k
- Avg merge
- 2d 11h
- Merged PRs (30d)
- 52
Description
Hi,
I was recently setting up a project to use ACLs, and found the docs for Postgresql mentioning that the JdbcMutableAclService needed to be configured for the ID queries (in the database-schema page).
When I switched the DB to MS SQL Server (2014), I found that it also needed to be configured to use 'select @@identity' for the ID queries.
Does this seem right? Should this also be added into the docs?
Cheers,
Matt
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the database-schema page and the PostgreSQL ACL documentation, then check how JdbcMutableAclService is configured for ID queries with Microsoft SQL Server 2014. Confirm whether select @@identity is required and document the SQL Server-specific configuration alongside the existing PostgreSQL guidance.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, postgresql, spring, sql
- Domain
- databases, documentation, security
- Issue type
- Documentation
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100