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 |
swekik
Posting Yak Master
126 Posts |
Posted - 2008-10-16 : 12:39:37
|
I am getting the following error.I gave all the permission that it requires.It has reader,writer,ddladmin,Role(to execute this StoreProc).Any clues??Severity: ERRORTimestamp: 10/15/2008 2:28:13 PMNode: Infoma02devThread: MAPPINGProcess ID: 3068Message Code: CMN_1022Message: Database driver error...CMN_1022 Exec IndexOptimize @database='Test'Microsoft OLE DB Provider for SQL Server: The user does not have permission to perform this action.SQL State: 42000 Native Error: 297State: 12 Severity: 16SQL Server Message: The user does not have permission to perform this action. |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-16 : 12:43:12
|
Can you explain what user is trying to do? |
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-10-16 : 14:08:32
|
Informatica service account |
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-10-16 : 16:31:26
|
I got the answer.I have to grant the view database state for that particular user. |
|
|
|
|
|