Hi,

please check if your users are NOT EXCLUSIVE!

http://www.sapdb.org/7.4/htmhelp/ee/1c5bcdeba711d4aa2800a0c9430730/content.htm

http://listserv.sap.com/pipermail/sapdb.general/2001-February/006635.html


regards
Wolfgang


-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Montag, 6. Januar 2003 20:01
To: [EMAIL PROTECTED]
Subject: SQL Studio "New Table Definition" menu item


Hi,

I have created user "GDBDBA" with DBA user mode.
This user owns group "GDBGROUP" and a user "GUSER" assigned to "GDBGRUOP".
"GUSER" has RESOURCE as user mode.

When I login as "GDBDBA" or "GUSER", I can't get "New Tabel Definition" context menu 
to enable. It is always disabled. How do I create new tables now?

I can write and execute SQL for create table, it works. But that's no substitute for 
using the create table dialog.

The "New Table Definition" menu is available when I login as SYSDB, which is my SYSDBA 
account.

Same is true for any new object creation menu, index, sequence etc.

Although, I can drop the objects while logged in as "GDBDBA" or "GUSER".

Any idea?

I am runnig 7.3 database with 7.4 sql studio. Is is okay to do it? If not, where can I 
get 7.3 SQL Studio and Manager?

Thanks in advance,
Prashant Rane

__________________________________________________________________
The NEW Netscape 7.0 browser is now available. Upgrade now! 
http://channels.netscape.com/ns/browsers/download.jsp 

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
_______________________________________________
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

Reply via email to