Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mnarewec
Starting Member
10 Posts |
 Posted - 2010-09-02 : 02:39:01
|
| Hi TeamI have added a db_Owner role to a SQL Authenticated user but that user is UNABLE to exec the stored procedure sp_addumpdevice. PWhen executed this command:exec sp_addumpdevice 'disk', 'NGALIMBIU100902', 'C:\NGALIMBIU100902.BAK'It gives this error:User does not have permission to perform this action.But I think db_owner should have full access to the database?We are using MS SQL 2000What could be wrong??? I have tired in using it programatically using VB6 and also with SQL Query Analyzer but same error.Marsh Narewec |
|
|
|
|
|
user has db_owner role but cannot execute cmds