[EMAIL PROTECTED] wrote: > > Hi, I am a new sapdb user. This is probably a very basic > idea but I am confused on exactly what needs to be done. I > created a new user and would like to know how to grant > privileges to this user from the DBA mode. I tried using the > grant/grant user statements but they were not working for me. > I need to edit/create tables under this new user and all of > the alter table/create table etc. commands are disabled, i > can only do things through the sql dialog which can get very > tedious at times. any help with this would be greatly > appreciated. thanks!
Unfortunately, I am sure not to understand exactly what your problem is. You have a user created with the CREATE USER SQL-statement, no matter if this user has RESOURCE, STANDARD or DBA-mode. Or do you have created a DBM-user? Please be aware of the different types of users: those for the database, which allow grants for them and those for usage of dbm. see http://www.sapdb.org/7.4/htmhelp/ef/002998f1fb11d4aa9a006094b92fad/frameset.htm 'Grant-statement was not working for me'. Mhm, what does this mean? What did you try? Which error occured. please be a little bit more precise. Every user created using CREATE USER SQL-statement and mode RESOURCE or DBA is allowed (without any grant) to create/alter tables for their own. They are not allowed to create tables for other users (connected user Elke is not allowed to do a CREATE TABLE jason.histable (....) ). Changes to those tables are allowed for other users (even for STANDARD-user) if they were granted the corresponding privilege. Now: what did you try and what happend? Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
