Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with security
Search options not deleted
user 72
Allowing users to access only the data they are authorized to access. It also encompasses protection of data during movement on the network and storage on disks and backups.
5
votes
2
answers
3k
views
Role db_ddladmin not working properly on SQL Server 2008
I want to allow certain user to create/modify objects on a database(tables, views, sp's, functions, schemas etc) and don't want to give db_owner.
I thought I could do it with the db_ddladmin role, bu …
- 347
0
votes
Accepted
Role db_ddladmin not working properly on SQL Server 2008
There's a workarround described in the Link of Sankar.
That works both with SQLSever 2008 and 2008 R2.
GRANT view definition on schema : "schemaname" to "username"
- 347