Hi, I tried that command while logged in as the DBA user(which has SYSDBA status on my program) and still have the same problem. All of the options are greyed out when logged in as the BPW user and changes can only be made through the sql dialog. Is there any other way to accomplish the task I stated before?
Thanks, J. Simoni In a message dated 7/11/2003 12:37:29 AM Eastern Standard Time, [EMAIL PROTECTED] writes: > J. Simoni wrote : > >Here is my problem. I was logged on as the DBA user and created a new user BPW with > >either resource or standard mode (can't remember which). >Logged in as the BPW user > >now, I COULD create and modify tables but everything would have to be done through > >the SQL dialog. This is because >all of the other available options before, for > >example, creating a table using the 'table definition' option (right clicking on > >the user BPW >and going to NEW, then to table definition.) are not available. > >Instead they are greyed out. Even the buttons on the bottom tab of the SQL > >dialog, such as 'Auto Commit' etc. are greyed out as well. This is a problem > >because I am trying to convert some ORACLE databases into SAP > >and need to change from internal to oracle mode so the ORACLE statements will > >execute correctly. > > >Now, taking all this into consideration, I did try something else, creating a user > >TEST (while logged in as DBA) with the DBA privilege. > >NOW, all the options I stated above are available under this user. So basically I > >am trying to figure out how to grant DBA status > >to the BPW user so all of the options will be available. I tried using the 'GRANT > >USER' statement: > >"GRANT USER BPW FROM DBA TO BPW" > >but keep getting a 'missing privilege' error in the status window, even though I > >was doing this while logged in as DBA. > > >Sorry for the long email! Some help with this problem > would be greatly appreciated/. > > >Sincerely Yours, > >J. Simoni > > Please connect as SYSDBA and execute > > ALTER USER BPW DBA > > Best Regards, > Thomas > > -- > Thomas Anhaus > SAP DB, SAP Labs Berlin > [EMAIL PROTECTED] > http://www.sapdb.org/ > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
