[EMAIL PROTECTED] wrote: > I connect to SAPDB as DBA and try to assign the role to user > (As I earlier > it did on Oracle database), > but I have a next error message after alter user command : > > create role dbadmin > // > grant select, delete,update,insert,references on > <My_TABLE_NAME> to dbadmin > // > create user pasha3 password p12345 > // > alter user pasha3 default role dbadmin > // > Error message : -5001, Syntax error or access violation;-5001 > POS(1) Missing > privilege.
You created a role and a user. But you never granted to role to the user. Therefore he cannot have this role as default role. The role is not known by him. And it does not matter if he (pasha3) himself or his dba (who knows the role) defines the default role for pasha3. He has to know (be granted) the role before. And here a short excerpt from Oracle's manual, chapter ALTER USER: DEFAULT ROLE Specify the roles granted by default to the user at logon. This clause can contain only roles that have been granted directly to the user with a GRANT statement. You cannot use the DEFAULT ROLE clause to enable: - Roles not granted to the user Therefore (if the manual and the implementation do not differ) SAP DB behaves as Oracle and you have only forgotten to grant that role. Elke SAP Labs Berlin
