Timeline for SQL Server - granting permissions to an entire schema vs. object?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 26, 2018 at 0:06 | comment | added | Traderhut Games | Doesn't work in Azure, any idea why? (the commands work, but SSMS comes up and says "you are not the Db owner.. blah blah blah. You might not be able to save the table" and sure enough, you can't (did a Grant ALL to the database (shows permissions 'Database', '<db name>', TheUserId, 'Create Table', and state_desc of 'GRANT') Is there some other magic that is needed? Or is Azure only usable by the Dbo? | |
| Apr 18, 2018 at 10:17 | comment | added | Joshua Duxbury |
Also use square brackets if the schema or username has special characters. e.g .... SCHEMA :: [schema] TO [company-name/joshua.duxbury]
|
|
| Jan 6, 2016 at 17:20 | vote | accept | user45867 | ||
| Jan 6, 2016 at 15:57 | history | answered | Mark Sinkinson | CC BY-SA 3.0 |