Timeline for SQL Server : which role grants permission to execute all stored procedures?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 4, 2020 at 12:05 | comment | added | D Kramer | The preferred way of adding users/members to a role is through the ALTER ROLE Foo ADD MEMBER Bar statements. sp_addrolemember is flagged as maintance and may be removed in the future. As per microsofts documentation. | |
| Nov 25, 2019 at 19:56 | comment | added | ΩmegaMan | Then exec sp_addrolemember N'role_exec_mySchema', N'{theDBUserName}'. :-) | |
| Aug 8, 2017 at 20:53 | vote | accept | Hikari | ||
| Jul 21, 2017 at 10:52 | review | Late answers | |||
| Jul 21, 2017 at 12:36 | |||||
| Jul 21, 2017 at 10:37 | review | First posts | |||
| Jul 21, 2017 at 11:56 | |||||
| Jul 21, 2017 at 10:32 | history | answered | Richard Armstrong-Finnerty | CC BY-SA 3.0 |