permissions mystery: ActiveDirectory issue?

From: Timo (Timo_at_unspam.biz)
Date: 06/23/05 

Date: Thu, 23 Jun 2005 11:54:32 -0400

I don't see why my user cannot see a view when she can see the tables that
underlie it and has also been granted select permission on the view.

exec sp_grantlogin [OURDOMAIN\user99]
exec sp_grantdbaccess [OURDOMAIN\user99], 'SARAH'

exec sp_addrole 'TheRole'
exec sp_addrolemember 'TheRole', 'SARAH'create view TestView
as select * from table1
inner join table2
on t1.id = t2.anotherid

grant select on table1 to TheRole
grant select on table2 to TheRole
grant select on TestView to TheRole

User SARAH can see the tables but not the view.

We're using SQL Server 2000 and Windows 2003 Server with ActiveDirectory.

Thanks
Timo

Relevant Pages

  • SQL views not accessible but tables are...
    ... exec sp_grantdbaccess, 'SARAH' ... exec sp_addrolemember 'TheRole', 'SARAH' ... grant select on table1 to TheRole ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Very elementary Q !
    ... account access to SQL Server using the sp_grantlogin procedure and then ... grant the account access to user databases using sp_grantdbaccess. ... EXEC sp_addrole 'MyRole' ...
    (microsoft.public.sqlserver.security)
  • Re: Permission to Insert records for DB USERS
    ... To add to the response by Vyas, consider creating your own database ... EXEC sp_addrole 'Supervisors' ... GRANT SELECT ON MyTable TO Supervisors ... > I am a fresh developer for the SQL server and have no Idea> for the permissions on the database. ...
    (microsoft.public.sqlserver.security)
  • Re: EXEC Permission on a entire DB
    ... Vyas, MVP (SQL Server) ... Within the Stored Procedure option in a DB, can you grant ... EXEC on each SP with a command. ...
    (microsoft.public.sqlserver.security)
  • Re: grant execution permission
    ... execute permission to the user/role: ... EXEC sp_addrolemember 'MyRole', 'MyDomain\MyUser' ... GRANT EXEC ON MyProcedure TO MyRole ...
    (microsoft.public.sqlserver.security)