Search this blog
-
The Current Book
MVP Award
Tags
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career2
- car update
- Cloud Computing
- conferences
- 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
- machine learning
- mcm
- Microsoft
- misc
- monitoring
- networking
- NoSQL
- PASS
- Performance
- powershell
- presentations
- Redgate
- republish
- sabbatical
- security
- software development
- software development
- speaking
- SQL Compare
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- Tesla
- testing
- travel
- tsqlt
- vacation
- version control
- webinar
- windows
- work
Search this blog
Steve’s Tweets
- @billinkc A bit of workbut this always goes over well food.com/recipe/cream-o… 28 minutes ago
- @SQLMCT @SQLBits @SQLSatATL I'll have to give it a try 35 minutes ago
- RT @GFritchey: Why attend #PassDataCommunitySummit? Well, to say "Hi" to me of course! Or, watch this video to see a bunch of other reason… 2 hours ago
- @SQLMCT @SQLBits @SQLSatATL Enjoying the read? 2 hours ago
- Registered for the Data Community Summit voiceofthedba.com/2022/10/05/reg… 2 hours ago
- RT @pmpjr: Is running a 100 attendee #sqlsat event worth it? Would you as a speaker show up deliver a session at that event? #sqlfamily 3 hours ago
- Today's editorial: The Value of Seniority voiceofthedba.com/2022/10/05/the… 3 hours ago
- Me from Colorado, @SQLEspresso from my hometown, Va Beach, @pshore73 from Ohio, @jdanton from Philly, and more. It'… twitter.com/i/web/status/1… 3 hours ago
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career2
- car update
- Cloud Computing
- conferences
- 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
- machine learning
- mcm
- Microsoft
- misc
- monitoring
- networking
- NoSQL
- PASS
- Performance
- powershell
- presentations
- Redgate
- republish
- sabbatical
- security
- software development
- software development
- speaking
- SQL Compare
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- Tesla
- testing
- travel
- tsqlt
- vacation
- version control
- webinar
- windows
- work
Older Posts
Meta
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
Voice of the DBA 