Re: Qery Analyser - Table Access
- From: "Hari Prasad" <hari_prasad_k@xxxxxxxxxxx>
- Date: Fri, 7 Oct 2005 22:59:19 +0530
Hi,
Table name is created as [Jim.Customers].
So you have to use :-
Select * from jim.[Jim.Customers]
Thanks
Hari
SQL Server MVP
"Jim Bunton" <jBunton@xxxxxxxxxxxxxxxx> wrote in message
news:4pw1f.77602$iW5.66654@xxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Sql Server 2000, Win 2000
>
> Problem accessing tables in SQL Query Analyser:-
> ?? why can't I access the database connected as Jim ??
>
> Created Database [SolutionsNet] - Owner Jim
> Created Table [Jim.Customers] Owner Jim
>
> Data base access Jim 'permit'
> Table - Companies - permissions Jim > Select . . . [the lot]
> Jim Permissions - Table Companies > Select . . . [the lot]
> Jim - permit in database role > public, db_owners . . [the lot]
>
> BUT
>
> SQL Query Analyser
> Connect as Jim
>
> use SolutionsNet
> go
> select * from jim.companies
> go
>
> Server: Msg 229, Level 14, State 5, Line 1
> SELECT permission denied on object 'Companies', database 'SolutionsNet',
> owner 'Jim'.
> [same if table is just 'companies' withot the prefix]
>
> HOWEVER
> Connect as sa
>
> use SolutionsNet
> go
> select * from jim.companies
> go
>
> Fine:- displays the empty table!
>
> ?? why can't I access the data connected as Jim ??
>
>
> Jim Bunton
>
> 283 968
>
>
.
- References:
- Qery Analyser - Table Access
- From: Jim Bunton
- Qery Analyser - Table Access
- Prev by Date: Re: Qery Analyser - Table Access
- Next by Date: Re: server side trace not working
- Previous by thread: Re: Qery Analyser - Table Access
- Index(es):
Relevant Pages
|
