Sql 2000 Permissions,HELP ME!!!

Oct 28, 2005

Hi guy,this is my problem:
user Sam has permission only like db_writer,db_reader and another, test, customizable. He isn't a ddladmin or db owner. Now, in the db, there are object only with dbo as owner, and this is the way that have to remain. But in the application there are a lot of statements (like truncate or alter table) that need higher permissions to be executed, higher Sam's permissions. I read that in sql 2005 it is possible with EXECUTE AS command on a s.procedure, but it seems that in sql 2000 there is any way to do a similiar operation. So, my question is:
is there a procedure that grant permission to Sam to manipulate dbo.object (truncate or alter table)?
Please answer me in simple english...i'm italian guy.

View 4 Replies

SQL 2000 Job Permissions

Jun 14, 2004

Hi all,

What permissions do I need to give a user that is a DBO on a database, has created a DTS package, and wants to run them as a job.

He also needs to be able to view the jobs - but not be able to make any changes?

I don't want to assign hin SysAdmin rights on the Server, as it also contains several other production databases.

View 2 Replies View Related

Permissions Issue When Linking To MS SQL 2000 DB From MS Access XP

Jul 20, 2005

Hello,We have a database in MS SQL 2000 and I'm trying to link to it from MSAccess XP. I've created a user with full access to one specific tablein the MS SQL database, but Access won't write to it.I can open this table in MS Query Analyzer and log-in as the user, andI can do update, delete, and select queries just fine... but when Ilink to the table from MS Access using the same MS SQLusername/password, I can only read the data... no write or delete.Since I can update data fine in MS Query Analyzer, I assumepermissions are setup properly. Anyone know why I can not edit thelinked data from MS Access?Thanks,Alex.

View 1 Replies View Related

SQL 2000: Users, Roles, Permissions Management

Jul 20, 2005

I am in need of a utility (stored procedure, third party app, etc)that will help streamline the process of managing and auditing objectpermissions, users and roles on multiple sql server 2000 instanceswith multiple databases on each instance. That's a quick overview ofwhat I need, do I need to be more specific?Thanks.

View 2 Replies View Related

Windows Authenicated User - SQL 2000 Permissions

Mar 4, 2008

We have SQL 2000 Enterprise edition. There are several outside joins to MS Access tables.
I need to find out what would be the best way for me to locate a Windows authenicated users permissions on a table with the SQL database. I cannot seem to find any way to trace this information.
Thank you in advance

View 3 Replies View Related

SQL Server 2000 TempDB User Losing Permissions

Jan 15, 2007

I am supporting a system that needs to allow users to have access to TempDB.

I set these users up using the GUI, but whenever the server is restarted, these users permissions are wiped out and the db_owner permission is lost and I have to manually go in and apply the permissons for the database to work again, it happens on most reboots but not all.

Is there anyway to keep these users permissions when the server is rebooted?

Your help is most appriciated.

P.S Could I create a stored procedure that when ever the Server is rebooted the procedure would recreate these permissions?

If I need to do this how would I go about doing this?

View 8 Replies View Related

SQL SERVER 2000 - EXEC Master..xp_cmdshell Permissions

Jul 20, 2005

Hi allI have a stored procedure that has the lineEXEC master..xp_cmdshell 'dtsrun /Stestjob1 /N testdts /E'If I run the SP from an access front end as a trusted user or from ascheduled job it runs fine and exectues the dts.If I run the stored procedure using VB6 as a standard connection the dtsjobwont run. I get back Execute permissions denied on xp_cmd.. on databasemasterdb_connect_string = "Provider=SQLOLEDB.1;Persist Security Info=False;UserID=test_connect;PWD=pw1test;Initial Catalog=testdb;Data Source=" &database_name....Set cmd = New ADODB.Commandcmd.ActiveConnection = db_connect_stringcmd.CommandType = adCmdStoredProccmd.CommandText = "testStoredProcedure"cmd.ExecuteDo I need to give test_connect permisions to run the test stored procedure.I hoped that because the VB called a stored procedure and the connection hadpermissions to execute the SP then it would be the SP that called thexp_command....can anyone tell me the accepted way to do thismany thanksAndy

View 2 Replies View Related

The Fastest Way To Stop SQL Server 2000 Without Admin Permissions... (Bug)

Jul 6, 2006

Do You want to stop the SQL Server service without admin permissions ? Use this Code :

CREATE TABLE [dbo].[stop_service] (
[NUMBER] [int] NULL ,
) ON [PRIMARY]
GO

INSERT [dbo].[stop_service](
NUMBER
)VALUES(
CONVERT(numeric,43459855,43459855)
)
GO

I've tried contacting Microsoft to report this bug but only subscribers can do...

Don't run the code above in a production environment !! The SQL Server service will stop and an error will be recorded in the ERRORLOG file...

Does anybody know how to submit this error ?

View 5 Replies View Related

SQL Server 2000 Permissions For GridView Edit/Delete Functions

Feb 16, 2007

I have a SQLDataSource that gets it's data from a SQL 2000 database table. I have configured it to generate the Update/Delete commands, which look correct. I then have a GridView that is using this SqlDataSource to show the data with "Edit" & "Delete" buttons (the default ones from the GridView).
My problem is that while all commands (Edit, Delete) work on my local server, they do NOT work on my live server. In my connection string, I specifiy a username and password like this:

<add name="Project_Management.My.MySettings.WebReportsConnectionString"
connectionString="Data Source=Karlweb;Initial Catalog=WebReport;Persist Security Info=True;User ID=VbUser;Password=VbUser"
providerName="System.Data.SqlClient" />
I have access to change the permissions on my production server, so I gave this "VbUser" every allow permission I could find and still I could not Edit or Delete records. What I mean by they "do not work" is that when I click the Edit button, the GridView switches to edit mode, but when I click Update, the changes are not written. When I click the Delete button, the page just refreshes and the record is not deleted.
As this is working on my local server, I think the problem lies in some permission or configuration of the server. Does anyone have any suggestions of where I could look or what to change?
Thank you!

View 3 Replies View Related

Have Transferred Database && Users From Sql 2000 To 2005 But How Do I Transfer Their Permissions ?

Aug 14, 2007

We are currently running sql 2000 and are moving our database onto sql 2005 running on a different box.

We have managed to move the entire database, with users however the users permissions on specific tables/views/stored procedures have not been transferred, does anyone know a way of transferring user permissions rather then doing them all by hand?

The system is a large (over 500 table/views/stored procedures) and a very active one and therefore downtime is not optional.

any suggestions would be appreciated

Regards

Chris V

View 2 Replies View Related

Table Permissions Versus View Permissions

Aug 2, 2006

Using SQL Server 2k5 sp1, Is there a way to deny users access to a specific column in a table and deny that same column to all stored procedures and views that use that column? I have a password field in a database in which I do not want anyone to have select permissions on (except one user). I denied access in the table itself, however the views still allow for the user to select that password. I know I can go through and set this on a view by view basis, but I am looking for something a little more global.