SQL 7.0 Stored Procedure Execute Privileges Only?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Edbar
    #1

    SQL 7.0 Stored Procedure Execute Privileges Only?

    SQL 7.0 Stored Procedure Execute Privileges Only?

    Does anyone know if a user/pass can be set up to give
    a sql 7.0 user stored procedure execute privileges only.

    That way, even if they get into the database, they can
    do nothing except run the stored procedures.

    Thanks,
    Ed


    Tags: None
    • John Bell
      #2
      Re: SQL 7.0 Stored Procedure Execute Privileges Only?

      Hi Ed

      Check out the GRANT command in Books Online.

      John

      "Edbar" <edbar@exmsft.c om> wrote in message
      news:FpT%f.1351 $pi6.576@dukere ad12...[color=blue]
      > SQL 7.0 Stored Procedure Execute Privileges Only?
      >
      > Does anyone know if a user/pass can be set up to give
      > a sql 7.0 user stored procedure execute privileges only.
      >
      > That way, even if they get into the database, they can
      > do nothing except run the stored procedures.
      >
      > Thanks,
      > Ed
      >
      >[/color]


        Comment

        • Jack Vamvas
          #3
          Re: SQL 7.0 Stored Procedure Execute Privileges Only?

          Yes, you can eitther do it through Enterprise Manager or use
          GRANT EXECUTE on mySp TO PUBLIC (or whatever user )
          there is also a DENY

          --
          Jack Vamvas
          _______________ _______________ _____
          Receive free SQL tips - www.ciquery.com/sqlserver.htm

          "Edbar" <edbar@exmsft.c om> wrote in message
          news:FpT%f.1351 $pi6.576@dukere ad12...[color=blue]
          > SQL 7.0 Stored Procedure Execute Privileges Only?
          >
          > Does anyone know if a user/pass can be set up to give
          > a sql 7.0 user stored procedure execute privileges only.
          >
          > That way, even if they get into the database, they can
          > do nothing except run the stored procedures.
          >
          > Thanks,
          > Ed
          >
          >[/color]


            Comment

            • Ajay Rengunthwar
              #4
              Re: SQL 7.0 Stored Procedure Execute Privileges Only?

              If you are looking to restrict access through application You can think
              of.....
              Application role, which allows you to create a role for your
              application and grant only this role the proper rights. This role
              requires a separate password authentication before granting the rights
              associated with the role. So, the user can log in with his own ID and
              password. Make sure in your application, you use the sp_setapprole with
              a password that only you and your application know to activate the
              proper rights. Although the user will be able to log in to SQL Server
              through another tool, he will not be able to access without knowing the
              password for the application role.

              Hope this helps.

              Thanks
              Ajay Rengunthwar
              MCDBA,MCAD

                Comment

                Previous template Next
                Working...