-
How do I allow non-SA to use DBCC from VB app ?
Can I allow a non SA account to issue DBCC or TRUNCATE TABLE on a DBO table ?
I've tried setting this up in a SP where I've granted execute only to the user but the user receives "Only the DBO of the database may run the DBCC UPDATEUSAGE command".
Do I have to set the user up as an alias to DBO ? I'd rather not.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|