brahmanandareddy
New User
Joined: 16 Dec 2004 Posts: 44 Location: Hyderabad
|
|
|
|
Hi Ganga,
First, post ur queries in new topic...
Here the answers are...
suppose if i am creating a table as
USERID.STAFF
DB2.STAFF.
if i am writing a query as select * from staff...
which staff it will select
A. If u mention select * from staff....the staff (if it exists) table created under the userid currently u r logged in will be retrieved. If it is not there in the current user id u will have to specify userid for which u should have previleges to access it.
Thank You,
Brahmananda Reddy. K. |
|