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-engineering-part1

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!

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply