Community Circle
Search this blog
Steve’s tweets
- @MSFTSecurity this link is broken download.microsoft.com/download/0/9/2… 12 minutes ago
- RT @alicegoldfuss: Whenever I post about D&I initiatives and hiring URMs, people say: but where do I find them? And this is the wrong appr… 17 minutes ago
- Chopping Off Data voiceofthedba.com/2020/10/19/cho… 38 minutes ago
The Current Book
MVP Award
Tags
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career
- cell phone
- Cloud Computing
- containers
- continuous delivery
- continuous integration
- coping
- data
- data analysis
- database design
- databases
- Database Weekly
- data privacy
- dbatools
- DevOps
- disaster recovery
- DLM
- encryption
- Friday Poll
- GDPR
- Git
- goals
- hardware
- high availability
- Humor
- life
- Linux
- mcm
- Microsoft
- misc
- monitoring
- networking
- NoSQL
- PASS
- patching
- Performance
- powershell
- presentations
- Redgate
- republish
- sabbatical
- security
- software development
- software development
- speaking
- SQL Change Automation
- SQL Clone
- SQL Connections
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- testing
- travel
- tsqlt
- vacation
- version control
- webinar
- windows
- work
Daily Archives: September 16, 2010
Rights for one table
I ran across a thread that was asking how to grant rights to a person for one table only, and not other tables. My response is simple: CREATE ROLE MySingleTableRoleGOGRANT SELECT ON dbo.MyCustomers TO MySingleTableRoleGOEXEC sp_addrolemember ‘MySingleTableRole’, ‘Steve’ That’s it. … Continue reading
Posted in Blog
Tagged security, sql server, syndicated, T-SQL
