sql server table permissions question
From: Chris (Chris_at_discussions.microsoft.com)
Date: 05/20/05
- Next message: Jerry Spivey: "Re: sql server table permissions question"
- Previous message: Jason Delaune: "Re: SQLAgent Jobs Not Available after SP4 Applied"
- Next in thread: Jerry Spivey: "Re: sql server table permissions question"
- Reply: Jerry Spivey: "Re: sql server table permissions question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 20 May 2005 08:21:03 -0700
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
- Next message: Jerry Spivey: "Re: sql server table permissions question"
- Previous message: Jason Delaune: "Re: SQLAgent Jobs Not Available after SP4 Applied"
- Next in thread: Jerry Spivey: "Re: sql server table permissions question"
- Reply: Jerry Spivey: "Re: sql server table permissions question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]