BUG:Backslash (DOMAIN\USER) is missing in grant statement
Backslash used in domain user account (DOMAIN\USER) is missing in GRANT statements.
for the solution until CR# 752095 is solved by SAP
Short description | |
user in grantstatement generated wrong | |
Version | |
PowerDesigner 16.1 EBF 13 |
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!