Re: SQL Local Account Permission - Read Only on System Tables and View
- From: "Russell Fields" <russellfields@xxxxxxxxxx>
- Date: Fri, 28 Dec 2007 14:49:22 -0500
ASP_Paul,
SQL Server 2005 tends to lock down information that SQL Server 2000 gave
away freely. So, most users can only see things that directly connect to
their rights. Other rights can be granted, if a logon needs more
information than the default. Look at some of the new types of GRANT
permissions.
Server Level:
VIEW SERVER STATE
VIEW ANY DEFINITION
VIEW ANY DATABASE
Database Level:
VIEW DATABASE STATE
VIEW DEFINITION
Only use these as appropriate to your security standards, of course.
RLF
"ASP_Paul" <ASP_Paul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CEB3585E-89C7-48E8-BEE7-1165A0DACC9B@xxxxxxxxxxxxxxxx
I have been given the task of creating a local SQL account (Application
account) on our 2005 SQL server for the use of a custom application that
will
look at the status of jobs/packages/etc... The application user id has
been
granted 'select access' to a list of tables provided by our development
staff. However I am running into problems with 2 system views. I granted
select on each view and have the following problem:
SQL:
select * from master..syslogins
Results:
Only 2 records, and both records are the 2 SQL accounts of SA and the
Application ID I created.
SQL
select * from dbo.sysschedules_localserver_view
Results:
No rows. I know there are 40 records when selected as an Admin account.
I was able to work around the problem by created a stored proc as such:
CREATE PROCEDURE dbo.aspSyslogins
WITH EXECUTE AS OWNER
AS
select * from master..syslogins
GO
GRANT EXECUTE ON dbo.aspSyslogins TO public
GO
However, I would rather figure out why I can not select directly against
the
view as this was this was the request given to me by our Dev staff.
.
- Prev by Date: Re: Audit Trace Files
- Next by Date: Re: NT Authority\networkservice failed to connect
- Previous by thread: Cannot connect with the Administator account
- Next by thread: Securing a Server Install
- Index(es):
Relevant Pages
|
