question about granting privileges

[JSimoni1]

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