RE: SQL Studio Scoping Problem

2004-06-07 Thread Stausberg, Markus
thanks for reporting. regards, Markus Stausberg SAP Labs Berlin > -Original Message- > From: John Singleton [mailto:[EMAIL PROTECTED] > Sent: Monday, June 07, 2004 5:16 PM > To: Stausberg, Markus > Cc: [EMAIL PROTECTED] > Subject: Re: SQL Studio Scoping Problem > >

Re: SQL Studio Scoping Problem

2004-06-07 Thread John Singleton
Hi Markus, Do you know if this will be corrected in the future? I'm trying to figure out how to document it. If this won't be corrected in the future, SQL Studio is limited to creating synonyms for objects the current user owns. In theory, however, SQL Studio could create a synonym for any obje

RE: SQL Studio Scoping Problem

2004-06-07 Thread Stausberg, Markus
Hello John, you wrote : > I have two users, DBA, and DBA2. I also have 2 tables FOO and > BAR. FOO > belongs to DBA and BAR belongs to DBA2. DBA has all > privileges on DBA2's > tables and vice-a-versa. > > Now: In sqlcli I can use the create synonym statement to create a > synonym like this

SQL Studio Scoping Problem

2004-06-04 Thread John Singleton
Hello All, I just ran into a rather odd problem in SQL Studio and I was hoping someone could clear the air. I have two users, DBA, and DBA2. I also have 2 tables FOO and BAR. FOO belongs to DBA and BAR belongs to DBA2. DBA has all privileges on DBA2's tables and vice-a-versa. Now: In sqlcli I