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
