Timeline for Grant access to all tables of a database
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 15, 2018 at 6:29 | history | tweeted | twitter.com/StackDBAs/status/964023769349181440 | ||
| Feb 15, 2015 at 0:31 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
add tags, minor edit
|
| Feb 15, 2015 at 0:29 | answer | added | Erwin Brandstetter | timeline score: 36 | |
| Feb 14, 2015 at 12:43 | comment | added | d33tah | I'd like to grant all CRUD to all tables in the database. Also, DROPping and CREATEing inside of this database could also prove useful. | |
| Feb 14, 2015 at 12:41 | comment | added | Kris Gruttemeyer |
Why can't you just GRANT SELECT ON TableName TO [Domain\User]? I usually just assign users to the db_datareader role if all they need is read access to all the tables but I'm not sure how granular you want to be.
|
|
| Feb 14, 2015 at 12:19 | review | First posts | |||
| Feb 14, 2015 at 14:05 | |||||
| Feb 14, 2015 at 12:18 | history | asked | d33tah | CC BY-SA 3.0 |