Security | Forum profile

More precisely it means that this login is a member of the sysadmin server role. You can see which members there are with this query:   SELECT u.name, r.name   FROM   master.sys.server_principals u   JOIN   master.sys.server_role_members rm     ON   u.principal_id = rm.member_principal_id   JOIN   master.sys.server_principals r    ...

Tom, The raw data is kept in dbo.sysprotects, although you may find the sp_helprotect stored procedure makes it easier to read.  Both of these run in the context of the current database. SELECT * FROM dbo.sysprotects WHERE id = OBJECT_ID('storedprocedurename') EXEC sp_helprotect @name = 'storedprocedurename' RLF > Does anyone know what's the name of the system view, where the execute > privileges...

Yes, I can connect as a non-domain admin using SQL Enterprise Manager.  I browse to the various DBs that this program uses and I can add, delete, and edit at will. >> Windows 2003 server with SQL 2000 latest SP. SQL 2000 is installed in >> mixed mode. I have packages like Microsoft Dynamics that have their own [quoted text clipped - 22 lines] > under the hood. Or search on the web to see if other...

Thank you for your reply. We are running SQL 2000 - is the script for SQL 2005? It will not execute for SQL 2000. > Robin, > [quoted text clipped - 36 lines] > > .

Dear Erland, thanks for your response. I've executed the stored procedure, it returned 1 - which means that my user is a member of BUILTIN\Administrators. I just do not know why at all. Checking the Groupmembership of that user by running Windows "Local Users and Groups" it shows that this user is a member of "BUILTIN\Users" - but not if "BUILTIN\Administrators". To reproduce follow...

First off thanks for responding... and good question. Sorry I neglected to explain this part. I told the app user he would need static IP at the head office; that other computers outside head office )current LAN) would need to use the static IP to connect to the head office. My reasoning is dynamic IP changes now and then... when the router is powered down and up >>Now, the user of the application opened another office in another...

Hi all, I'm continuously receiving the following error messages in the server event logs: Msg 18456, Level 14, State 1, Server <xxxxx>, Line 1 Login failed for user 'sa' Msg 18456, Level 14, State 1, Server <xxxxx>, Line 1 Login failed for user 'administrator' Msg 18456, Level 14, State 1, Server <xxxxx>, Line 1 Login failed for user 'admin' Similar happens for FTP as...

Hi Stm, I think, you may got the solution for this. I have this  same question now, can forward me the solutions or how you handled the situation. My email address: sjdevarajan@hotmail.com Thanks. regards, S.Devarajan. SQL 2005 express security issue 01-Feb-08 Hi We just revamp our application from Access to use SQL Express 2005 as database engine, which is a standalone application running on client PC I'm now simulating the...

i was having the same problem and your answer helped. yay!!! Hello,You may need to do 2 steps, first one is to change the authentication 28-May-07 Hello You may need to do 2 steps, first one is to change the authentication mode to SQL Server and Windows. After that chnage the SA password Use the below steps: 1. Login as a local admin in SQL Server machin 2. Open the SQL Server express management studi 3. Connect to SQL Server using windows...

Does anyone know what's the name of the system view, where the execute privileges for stored procedures and functions are stored in SQL Server 2000? In other words: The privileges for tables and views are stored in system view INFORMATION_SCHEMA.TABLE_PRIVILEGES, but how can I determine the execute privileges for stored procedures and functions? Many thanks in advance for your help!