Re: Lost User rights / permissions

From: BP Margolin (bpmargo@attglobal.net)
Date: 03/14/03 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Fri, 14 Mar 2003 08:25:38 -0500

Damian,

Is there a chance that this user is in a role, and the permissions on the role are changing?

You might try running SQL Profiler and capturing some events in the Security Audit class to see if someone is "messing" with the permissions, either accidentally or intentionally.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Damian" <damian.cullen@melbournemarkets.com.au> wrote in message news:073901c2e9c7$63ca4800$3401280a@phx.gbl...
> No databases have been restored when this happens. its
> just one day the user has access with specific rights to
> a database and the next day they dont.
>
>
> >-----Original Message-----
> >Is the database being restored using a backup from
> another server? I'm
> >thinking about orphaned users.
> >
> >--
> >HTH,
> >Vyas, MVP (SQL Server)
> >SQL Server FAQ, articles, code samples, interview
> questions and more @
> >http://vyaskn.tripod.com/
> >
> >
> >
> >
> >"Damian" <damian.cullen@melbournemarkets.com.au> wrote
> in message
> >news:037d01c2e9b3$2fec5370$a101280a@phx.gbl...
> >I have 2 login accounts that infrequently lose all of
> >their permissions and rights to databases and stored
> >procedures.
> >
> >1 has read access to 2 databases, while the other has
> >rights against a stored procedure.
> >
> >No other accounts are being affected, there are no errors
> >appearing in the event logs, and the server has been
> >upgraded to the latest service pack and hot fixes.
> >
> >Can anyone help me with why this may be occuring
> >
> >Thanks
> >
> >Damian
> >
> >
> >.
> >

Relevant Pages

  • Re: Exchange Move Issues?
    ... I'm a bit confused on what permissions to assign for SBS, ... When you finish moving the databases, ... You can move the log files and database files to any folder that you want to ... Note Only assign permissions to the Server Operators group if the Exchange ...
    (microsoft.public.windows.server.sbs)
  • Re: How to I get a list of databases?
    ... Same permissions quandary, but EM uses the sp_databases system stored ... Since I don't have admin rights to their server, ... was able to deduce which databases I can access. ... I have used ADOX to get a list of tables in a database, ...
    (microsoft.public.inetserver.asp.db)
  • Re: Move 10 DBs and provide dev access thru EM?
    ... but I tried this on a test server and the DBs ... Permissions should not have been lost if you simply detached and re-attached ... can I provide access to the databases for our developers through ...
    (microsoft.public.sqlserver.security)
  • Re: Move 10 DBs and provide dev access thru EM?
    ... I know my procedure is correct as I did this on a test server this morning ... but I tried this on a test server and the DBs ... Permissions should not have been lost if you simply detached and re-attached ... roles in all databases or can I assign a single role and apply to all? ...
    (microsoft.public.sqlserver.security)
  • Re: write with cURL
    ... execute permissions. ... of potential security risks from other users on the same server. ... I made this suggestion because their web host appears to run Apache ... risk to allow Apache's group write access, since all PHP scripts ran ...
    (alt.php)