Thanks Re: Query Analyser Owner, table access

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks for the reply Tibor - of course - I clicked ALL the roles "to make
sure I had all accesses!!"

Well I feel like a fool but you look like a real WIZ

thanks again

"Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx> wrote in
message news:O8ts5iy0FHA.3756@xxxxxxxxxxxxxxxxxxxxxxx
> Perhaps Jim is in the db_denydatareader role?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
>
> "Jim Bunton" <jBunton@xxxxxxxxxxxxxxxx> wrote in message
> news:CmO4f.135772$RW.6675@xxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> SQL SERVER 2000 Personal Edition
> Win 2000
>
> Connect using SqlServer Authentification
> Jim **pw**
>
> Run the following to create a new table:-
> --------------------------
> USE SolutionsNet
> GO
> CREATE TABLE
> Companies
> (CompanyId INT PRIMARY KEY IDENTITY(1,1),
> Companyname VarChar(50) NOT NULL,
> IsaRestaurant BIT,
> . . . . .
> )
> GO
> --------------------------
>
> Then the following:-
> --------------------------
> Use SolutionsNet
> GO
> SELECT * FROM Companies
> REM OR select * from jim.Companies
> GO
> --------------------------
> Server: Msg 229, Level 14, State 5, Line 1
> SELECT permission denied on object 'Companies', database 'SolutionsNet',
owner 'Jim'.
>
> BUT
> connect as sa **pw**
> --------------------------
> USE SolutionsNet
> GO
> SELECT * FROM Jim.Companies
> GO
> --------------------------
> Displays the empty table Ok
>
> [NB. just Companies without tyhe prefix Jim. does not display the empty
table
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'Companies'. ]
>
> ????
> Why can I not access the table connected as Jim - it's owner !!!
> ???
>
>
>
> Jim Bunton
>


.

Relevant Pages

  • Re: Owners Access to table
    ... > USE SolutionsNet ... > Displays the empty table Ok ... just Companies without tyhe prefix Jim. ... > Why can I not access the table connected as Jim - it's owner!!! ...
    (microsoft.public.sqlserver.connect)
  • Qery Analyser - Table Access
    ... Problem accessing tables in SQL Query Analyser:- ... Created Database [SolutionsNet] - Owner Jim ...
    (microsoft.public.sqlserver.tools)
  • Owners Access to table
    ... USE SolutionsNet ... Displays the empty table Ok ... Invalid object name 'Companies'. ... Why can I not access the table connected as Jim - it's owner!!! ...
    (microsoft.public.sqlserver.connect)
  • Re: Qery Analyser - Table Access
    ... SQL Server MVP ... why can't I access the database connected as Jim ?? ... > Data base access Jim 'permit' ... > SELECT permission denied on object 'Companies', database 'SolutionsNet', ...
    (microsoft.public.sqlserver.tools)
  • Re: File sized in inexplicable way
    ... Very occasionally it's impossible to clear the "empty" used range with all ... You could copy each sheet to new books and look at file ... ...All entire rows and columns (All formats and contents)" ... Jim Cone ...
    (microsoft.public.excel.programming)