Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member185199
Contributor

Backslash used in domain user account (DOMAIN\USER) is missing in GRANT statements.

see http://scn.sap.com/community/sybase-powerdesigner/blog/2013/11/28/series-mssql-server-reverse-engine...

for the solution until CR# 752095 is solved by SAP

Short description
user in grantstatement generated wrong
Version

PowerDesigner 16.1 EBF 13
XDB SQL Server 2008

When modelling Users with name which include a domain (DOMAIN\USERNAME ) the user is right created:
/*==============================================================*/
/* User: "HLB\a030926" */
/*==============================================================*/
create user "HLB\a030926" with default_schema = dbo
go

but the grantstatement goes wrong:
/*==============================================================*/
/* Table: testtable_permissions */
/*==============================================================*/
create table dbo.testtable_permissions (
testcol1 nchar(10) collate
SQL_Latin1_General_CP1_CI_AS null,
testcol2 nchar(10) collate
SQL_Latin1_General_CP1_CI_AS null,
testcol3 nchar(10) collate
SQL_Latin1_General_CP1_CI_AS null
)
on "PRIMARY"
go

grant INSERT,DELETE on dbo.testtable_permissions to "HLBa030926"
go


the backslash is filtered out of the name!

Labels in this area