Hi Thomas, Thanks for the reply. The issue ended up being was that the mixed case group name I added got switched to all upper case when I added it, and the GRANT statement is case sensitive. I set the name to all upper case and it worked fine.
Take Care -----Original Message----- From: Anhaus, Thomas [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 27, 2002 10:45 PM To: 'Jason Terando' Subject: RE: GRANT statement Hi Jason, -4003 means 'unknown user name', which indicates that SAPDB does not know 'Administrators' as a user, usergroup or role. >From your mail I have the impression, that you defined a usergroup 'Administrators', is that right ? If so, please have a look into table domain.users. Does your group 'Administrators' appear in any column GROUPNAME ? If true, do you see 'Administrators' or 'ADMINISTRATORS' in column GROUPNAME ? If false, you had a problem defining the usergroup, i.e. the usergroup does not exist. If you see 'Administrators' you have to specify the group name in the grant statement as special identifier, which allows you to be case sensitive : GRANT INSERT, UPDATE, DELETE, SELECT ON CONTACTS TO "Administrators" If you have still problems after that, please tell me how you defined the usergroup and send me the content of table domain.users. Best Regards Thomas --- Thomas Anhaus SAPDB, SAP Labs Berlin -----Original Message----- From: Jason Terando [mailto:[EMAIL PROTECTED]] Sent: Donnerstag, 24. Januar 2002 15:47 To: [EMAIL PROTECTED] Subject: GRANT statement I have a table called CONTACTS, created as user DBA. I would like to grant privileges to a resource group I created called Administrators, also as DBA. I've tried executing the following statement in SQL Studio: GRANT INSERT, UPDATE, DELETE, SELECT ON CONTACTS TO Administrators Which gives me an error of -4003, invalid user name. Is this because I created the group as a resource group, or because my syntax is wrong? Thanks for any guidance. _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
