selective object restrictions

From: Support (RemoveThis_Support_at_mail.oci.state.ga.us)
Date: 05/25/05

  • Next message: Hari Prasad: "Re: selective object restrictions" 
    Date: Wed, 25 May 2005 11:09:16 -0400

    How can I create a user who has rights to create objects, ie, table, view
    and stored procedures in a database
    and no rights on any object someone else created.

    for example: in database DBA
    user A creates a table TABA
    user B creates a table TABB
    user A cannot deleted TABB
    Thanks
    T

  • Next message: Hari Prasad: "Re: selective object restrictions"

    Relevant Pages

    • Re: Data security
      ... look into using Stored procedures. ... > database. ... > the database and revoke rights at tat moment in time? ... > developers are developing and be comfortable that the data is secure? ...
      (microsoft.public.sqlserver.security)
    • Re: Application concerns OVER Login
      ... Giacomo, ... > 2) gave that user rights to specific stored procedures on database ... > or will they only have rights to the stored ...
      (microsoft.public.sqlserver.security)
    • Re: Limiting Selection of Data by User ID
      ... As MC suggested, do everything through stored procedures, with every ... Create a separate database for each company, ... database is as simple as scripting objects from one of the existing ones, ... but no rights to the table. ...
      (microsoft.public.sqlserver.programming)
    • How to determine the current users rights
      ... My .NET application needs to know if the currently logged on user has rights ... users of the database to use. ... Is there any defined stored procedures or views that returns that kind of ... Bob Trabucco ...
      (microsoft.public.vb.database)
    • How to determine the current users rights
      ... My .NET application needs to know if the currently logged on user has rights ... users of the database to use. ... Is there any defined stored procedures or views that returns that kind of ... Bob Trabucco ...
      (microsoft.public.dotnet.framework.adonet)