Re: sql server table permissions question

From: Jerry Spivey (jspivey_at_vestas-awt.com)
Date: 05/20/05 

Date: Fri, 20 May 2005 10:08:17 -0700

Chris,

Try refreshing at the tables collection in the tree view of EM (right
click - refresh) then revisit the permissions view.

HTH

J

"Chris" <Chris@discussions.microsoft.com> wrote in message
news:19411CBA-F941-4026-A4E3-00561EE761FC@microsoft.com...
> Hi,
>
> I have a SQL Server 2000 database. When I create tables in query analyzer
> or
> another tool the new table appears in enterprise manager under the table
> table after a refresh.
>
> When I go to the Users tab and click on a user and open up the properties
> window and thenthe permissions button I get a list of all the objects in
> the
> database.
> However the newly created table(s) do not show up in this list.
>
> How do I make them show up?
>
> Also this is leading to to another question: When accessing these tables
> in
> a Access Data project the only table I can edit is an old table that never
> shows up in the list metioned above. My ADP suddenly started to no longer
> have tables that were updatable and I think there might be a connection.
>
> any help would be greatly appreciated.
>
> thanks
>
> Chris