Re: Setting perm. on stored procedures using windows auth.

From: Adnan Selimovic (aselimovic@internet.ba)
Date: 01/07/03 

From: "Adnan Selimovic" <aselimovic@internet.ba>
Date: Tue, 7 Jan 2003 09:30:54 +0100

That was the problem. Thank you Wayne.

Adnan

"Wayne Snyder" <wsnyder@computeredservices.com> wrote in message
news:eHKrgQctCHA.1628@TK2MSFTNGP10...
> Without more details it is hard to say... However, if you are logged in to
a
> windows account and are in the local windows administrators group, that
> group ( by default) is part of the SQL Server Sysadmins group which gives
> complete permissions on the server... Is that what is going on for you?
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
>
> I support the Professional Association of SQL Server (PASS) and it
community
> of SQL Server professionals.
> www.sqlpass.org
> "Adnan Selimovic" <aselimovic@internet.ba> wrote in message
> news:exGdJZbtCHA.2544@TK2MSFTNGP11...
> > Hi folks!
> >
> > I have create 1 security login for a domain user and I have enabled
> Windows
> > Authentication. I added that 1 user to a database role and I set execute
> > permissions for some stored procedures in my database.
> >
> > The problem is that SQL 2000 ignores all that permissions and gives me
> full
> > access to the database. I set connection string correctly and enabled
> > Windows Integrated authentication on my web server.
> >
> > Does anybody knows why the permissions are ignored?
> >
> > Cheers from Sarajevo,
> >
> > Adnan Selimovic
> >
> >
>
>

Relevant Pages

  • Re: Setting perm. on stored procedures using windows auth.
    ... windows account and are in the local windows administrators group, ... I support the Professional Association of SQL Server and it community ... I added that 1 user to a database role and I set execute ... > permissions for some stored procedures in my database. ...
    (microsoft.public.sqlserver.security)
  • Re: Login with no Fixed Server Role and DB Role can stop SQL Agent Service?
    ... Yup - somehow the user has windows security rights to control services - we ... This posting is provided "AS IS" with no warranties, and confers no rights. ... >> a Window 2000 Login with Domain User default permissions, ... Forget about SQL Server for the moment. ...
    (microsoft.public.sqlserver.security)
  • Re: simple security question (need refresher)
    ... If IIS is configured for anonymous access and you connect to SQL Server ... using Windows authentication, the IIS anonymous account ... this account or roles that this account is a member of. ... Permissions are required only on objects directly accessed by the ...
    (microsoft.public.sqlserver.security)
  • Re: User setup problem.
    ... login permissions for SQL Server. ... have access to SQL Server and the database through their ... windows group role membership which has the permissions.. ...
    (microsoft.public.sqlserver.security)
  • Re: Excel Front End for SQL Server
    ... Just needed to change permissions for my account in the ... > Hi Wayne, ... >> I'm having no problem using SQL to retrieve records from my SQL Server. ... >> However I cannot delete records in my SQL Server from Excel. ...
    (microsoft.public.excel.programming)