Logins & Permissions

Hi,

I am using SQL Server 2005 on a Windows NT Network

This is not something that I have really had little to deal with in the past
but I am trying to get some understanding of logins and permissions, I know
that you can have either a SQL Server Login or a Windows Login and a Windows
one is what I am currently using and this allows you rights to do certain
things with the SQL Server and then you have logins for the databases which
give you access to do certain things within the databases, well that is what
I think it all does, but what I want to do is restric people from only being
able to run a stored procedure and view its results either through Query
Analyser or Crystal Reports but not allow them to alter the stored procedure,
if someone could offer me some advice on this and where I can find some basic
white papers or web sites that explain the basics of SQL Logins and
Permissions it would be much appreciated.

Thanks
tress
.

Relevant Pages

  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... Only creating Logins is not the complete solution of course, then you'll need to map those users to the appropriate databases and assign them roles and grant them permissons. ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... 2- Mixed Authentication (through SQL Server logins and Windows accounts) ...
    (microsoft.public.sqlserver.clients)
  • Re: Logins & Permissions
    ... At server level, we use "Logins" to connect to a SQL Server Instance and perform server level jobs. ... "Users" are used and these users are mapped to Logins. ... I am using SQL Server 2005 on a Windows NT Network ...
    (microsoft.public.sqlserver.security)
  • Re: Problem with SQL Server 2005 Express Edition
    ... Since you are specifying the user name and password in the connection string I assume you are using SQL Server authentication for your logins rather than Windows authentication. ... One cause for that error is trying to use a SQL Server login on a database server that is configured to only accept Windows logins. ...
    (microsoft.public.sqlserver.security)
  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
Quantcast