Re: Permission

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/06/04

Next message: MailMan: "SqlMail"
Previous message: anonymous_at_discussions.microsoft.com: "restore two databases from one device"
In reply to: Carrasco: "Permission"
Messages sorted by: [ date ] [ thread ]

Date: Tue, 6 Jul 2004 23:04:01 +0530

Hi,

Have a look into the procedure sp_helprotect in books online.

Thanks
Hari
MCDBA

"Carrasco" <Carrasco@discussions.microsoft.com> wrote in message
news:81C7D2F3-624D-4331-A257-5792D75CD82F@microsoft.com...
> Hi,
>
> is there a way to know every permission that a specific user has in the
SQl server using a Sql line ??
>
> I know individually ! But I would like a process that will look in all
databases all roles, and so on !
>
> Any help I'll apreciate !
> Thank's
>

Next message: MailMan: "SqlMail"
Previous message: anonymous_at_discussions.microsoft.com: "restore two databases from one device"
In reply to: Carrasco: "Permission"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: user defined Role - HELP
... does not have permission on tblUReport" am thoroughly stumped on why it ... This is because ownership chaining does not apply to TRUNCATE TABLE. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.security)
Re: Public Role for SQL 2000
... I tried to Revoke Select permission but not able to do that. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.security)
Re: Connecting To SSE with MSE
... CREATE DATABASE permission. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.connect)
Re: db_denydatawriter
... perhaps this also gives read write access on the database to this user? ... the fact that a user has permission to run a certain Windows ... does not give her any permissions in SQL Server. ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.security)
Re: INSERT Permission & Linked Servers
... One other data point that I discovered after my original post. ... then the users would need SELECT permission. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.security)