RE: Resource User can't create table with sqlstudio

Simon Spielmann wrote:

> > I created a user with "create user abc password xxx resource".
> > The user can create tables with sql commands in sql studio (e.g. 
> > create table).
> > But the menu items for creating tables using the gui are 
> greyed out. 
> > Modifying tables
> > is even impossible when the user owns the table, SQL Studio says 
> > "automation error" then.
> >
> >
> Strange,
> 
> I didn't do anything except granting not exclusive option for 
> user and 
> restarting db. and know it works
> Do I have to restart DB after adding a user?

As far as I know SQL Studio needs a second connection 
with the same user for the menu dialog.
So the not exclusive option makes the change.

Kind regards,
Holger
SAP Labs Berlin