Re: SQL 2008 db_datareader cannot display all tables
- From: "Daniel Jameson" <no_djameson_spam@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 2 Sep 2009 17:28:37 -0700
I solved the problem, sort of, by changing the schema owner to dbo. But
that nuked all the permissions on the objects in the schema, and I had to
put them back.
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"Joe K." <JoeK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3D9A3F11-50D2-4B8F-A634-4A827BF3BF20@xxxxxxxxxxxxxxxx
I have a SQL Server 2008 database server that was installed as the
Enterprise Edition. I set up several SQL Server logins with db_datareader
access rights to a database. The logins only display dbo schema tables in
the database. I changed the login default schema it still only displays
the
dbo schema tables. I changed the access priviledges to db_owner it
displays
all tables.
What change do I need to make so db_datareader displays all tables in the
database?
Please help me resolve this issue.
Thanks,
.
- References:
- SQL 2008 db_datareader cannot display all tables
- From: Joe K.
- SQL 2008 db_datareader cannot display all tables
- Prev by Date: Table Type Permissions
- Next by Date: Constant stream of NetBIOS queries from SQL Server 2005
- Previous by thread: Re: SQL 2008 db_datareader cannot display all tables
- Next by thread: Table Type Permissions
- Index(es):
Relevant Pages
|
Loading
