Hi, I was looking on SQLServer log files in EM, I found the following
message :
"EXECUTE permission denied on object 'dt_verstamp006', database 'mydaabase',
owner 'dbo'.."
just before this message there is :
"Error: 229, Severity: 14, State: 5"
So, what is "dt_verstamp006" object ? the user executing the sql is dbo user
Thanks in advance
Hello,
dt_verstamp006 was created when when you created and saved a database
diagram in Enterprise
Manager. Please refer to the following article for details:
327145 FIX: You cannot create diagrams in SQL Enterprise Manager if you are
not
http://support.microsoft.com/?id=327145
You may want to run following command to grant exec permssion to the SP
Grant exec on dt_verstamp006 to [user].
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: dt_verstamp006
| thread-index: AcVA048EkrLc/oC0RQKNwLeu08tSyQ==
| X-WBNR-Posting-Host: 194.51.27.4
| From: "=?Utf-8?B?U2FsYW1FbGlhcw==?=" <eliassal@.online.nospam>
| Subject: dt_verstamp006
| Date: Thu, 14 Apr 2005 02:23:03 -0700
| Lines: 8
| Message-ID: <EA9A9625-C77F-4B49-91B0-B1686B590F45@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| Path: TK2MSFTNGXA01.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:52446
| NNTP-Posting-Host: tk2msftngxa03.phx.gbl 10.40.2.157
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi, I was looking on SQLServer log files in EM, I found the following
| message :
| "EXECUTE permission denied on object 'dt_verstamp006', database
'mydaabase',
| owner 'dbo'.."
| just before this message there is :
| "Error: 229, Severity: 14, State: 5"
| So, what is "dt_verstamp006" object ? the user executing the sql is dbo
user
| Thanks in advance
|
Friday, February 17, 2012
dt_verstamp006
Labels:
database,
denied,
dt_verstamp006,
execute,
files,
followingmessage,
log,
microsoft,
mysql,
object,
oracle,
permission,
server,
sql,
sqlserver
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment