Permissions Question.. (hey, Didja Miss Me?)

Jul 1, 2004

Hi all,

Wow...since I've been gone, the search feature is apparently working again! Kewl!

However, after doing a search and not finding anything pertaining to my current issue, here I am again :D

I access a table on a linked server/database apart from my application's DB.

Every day, a process on the other server/DB drop and recreate the table....which, of course, zaps my user permissions. I then have to go into the Enterprise Mgr and re-enable my SELECT access to the table.

My question is this: Is there a way to auto-magically set my user ID on the linked server to give me access to the table without having to go in explicitly on a daily basis and re-enabling my UID Access rights.

This is the only table my user ID has been given access to on the remote server, so I am not able to simply set up my user ID on the remote system to "allow everything"

Am I missing something obvious? Do I have to create a SP on the remote server to do a daily GRANT SELECT ON Remote_Table TO Paul_Dammit after the table is rebuilt each day???

Suggestions?



It gets

View 3 Replies


ADVERTISEMENT

HIT And MISS

Nov 23, 2005

Hi Guru,My profiler trace does not display SP:CACHEMISS event, even thought Idrop store proc, clear both data cache and buffer cache but still doesnot work.Every thing works fine like: cachehit,cacheinsert,cacheremove,executecontexthit etc...Is there any special option that I need to turn it on?Please help,Thanks,Silaphet,

View 1 Replies View Related

What Do You Miss On SSIS?

Jun 2, 2006

Maybe a silly thing but can you imagine that the tasks showed Heigh,Left, Top location properties as whether they were VB's control?

View 4 Replies View Related

I Miss The Old Query Analyzer.

Aug 4, 2006

In QA from MSSQL2K5, is there a way Cntrl + W through the windows like there way in MSSQL2K5? I've tried and tried to find this type of setting and this is driving me nuts! :mad:

TIA, cfr

View 8 Replies View Related

Miss Tables In Replication

May 3, 2006

I have setup a transactional replication from oracle to MSSQL2005. One of the publication includes 26 articles but I found that there are only 24 articles replicated to the subscriber DB. I found that the repldata folder includes only files for 24 articles only. Besides, I double check the publication properties, totally, there 26 articles. Please advise. Thanks in advise.

View 2 Replies View Related

I Miss MS Access Crosstabs In SQL-Server ;-)

Apr 25, 2005

Hi there...
im my DB there is a table. Something like
Who, Value1, Value2, ...
John, 1, 2
Jim, 2, 2
Bob, 1, 1
Jack, 0, 0
Mike, 1, 1
...
 
Now i want to have as a result of a query:
Valuefield, 0, 1, 2
Value1, 1, 3, 1
Value2, 1, 2, 2
as the count of rows that equals 0, 1 or 2 to each column...
 
I know the select-case-statement in SQL-Server, but how do i get the columnnames in the first column??? I have 28 columns like that in my table...
 
hope you can provice help...
 
kind regards,
Cappu
 

View 5 Replies View Related

Do You Miss Query Analyzer In SQL 2005?

May 15, 2007

I tried. I really did to adapt to using Management studio as a replacement, but I just can't make the jump. I went ahead and installed SQL 2000 QA and have gone back to using it for ad-hoc query support and other routine SQL tasks. For me the main thing is the "Notepad-esque" lightness of QA compared to the heavier SQL tools that allows me to quickly open a SQL script file and get to work on it quickly. I appreciate an integrated tool, but I would like to see future versions allow you to use it either as a standalone or within integrated platform. Am I alone in this? Anyone else feeling this pain?

View 6 Replies View Related

Miss Match Between Column Type In A Cursor. Msg 8114, Level 16, State 5

Nov 16, 2006

hi

I have a float column . only in cursor I get a type missmatch.

does any one knows it ?

the error

Msg 8114, Level 16, State 5, Line 14

Error converting data type varchar to float.

the code

DECLARE @RON_FLOAT FLOAT

DECLARE RON_CURSOR CURSOR FOR

SELECT RON_FLOAT

FROM RON_TABLE1

OPEN RON_CURSOR

FETCH NEXT FROM RON_CURSOR

INTO @RON_FLOAT

WHILE @@FETCH_STATUS = 0

BEGIN



PRINT 'VALUE IS ' + @RON_FLOAT

FETCH NEXT FROM RON_CURSOR

INTO @RON_FLOAT

END

CLOSE RON_CURSOR

DEALLOCATE RON_CURSOR



the code for the table

CREATE TABLE [dbo].[RON_TABLE1](

[RON_FLOAT] [float] NULL,

[RON_CHAR] [nchar](10) COLLATE Hebrew_BIN NULL

)

View 1 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.

View 5 Replies View Related

Permissions

Apr 11, 2007

I am working http location and using sql server 2005 ,it is showing an error as " DELETE permission denied on object 'CourseDetails', database 'LOGIN', schema 'dbo'." CourseDetails is my table name and LOGIN is  my database name.

View 2 Replies View Related

BCP Permissions I Think

Feb 26, 2002

I am trying to setup a BCP command in a stored procedure it workds for me an administrator. i'm using a user's account in the username and password in the BCP command of a user that has DBO rights on the database i'm extracting the dat from. I can execute the stored procedure from my workstation and the server using my login account in QA. Using the username of the dbo account in QA i can get it to work at the server but not at my workstation orher workstation. my thoughts were that it was network permission related but i bumped her account to that of a domain admin and it still will only work on the server. it generates the following error.
The name specified is not recognized as an
internal or external command, operable program or batch file.

this is what i'm executing with the names changed to protect the innocent

EXEC MASTER..XP_CMDSHELL 'bcp file_test..table_out out C:filej.txt -U username -P password -c'
the environment is SQL7 on a 2000 Advanced server and we are running active directory.

i'm guessing it's something i'm just overlooking. i hope.
any help would be most appreciated.

View 1 Replies View Related

Permissions

Jul 17, 2002

Hi!
I have a user who needs only access SQL Server to see jobs in the job folder.
What permissions should be granted to this user?

Nora

View 2 Replies View Related

Not Getting SA Permissions

May 11, 2000

Hi ,
MY sysadministrator gave a sysadmin permissions to my login..,but i am not getting those permissions... when i check syspermissions system table it is showing my login id is having sysadming permissions...
when we checked his machine , in
security
serverroles
sysadministrators---properties--there it is showing my login-id..
but when i trying to click properties of servers it showing
'' ONLY MEMBERS OF THS SYSADMIN CAN ACCESS THIS FEATURE''''
why it is happening pls let me know..

thank u
kavira

View 3 Replies View Related

Permissions

Jun 22, 2000

When I restore a database, I lose login permission and role permissions. I end up going
into the login and unselect and reselect the database to make sure that the login works
with the database. Is there a way to get around this??

One other question:: I have added 65 new tables to a database and want to give select
only to all logins to those specific table -- is there an easy way of doing this???

View 1 Replies View Related

Permissions

May 16, 2000

WHat kind of permissions do you need to create a new job?
It looks like I am the only one that can since I have full administator rights. So I created the job and then changed ownership to another user,
but he cannot add a new step. WHen he tried to created a job he received message
ERROR 229 EXECUTE permission denied on object 'sp_enum-Sqlagent_subsystem'
database 'MSDB' owner DBO
I gave the user access to MSDB as DBO but it didn't make any difference.

View 1 Replies View Related

Permissions

May 17, 2000

Can anyone help me with this problem?
Is it possible for a user that runs one application against database A to update a table via a stored procedure i database B during runtime without beeing entered as a user in that database, i.e execute that stored procedure with a default or given user.
The reason is that we don't want to administrate an unknown number of users that will have no access to that database except via that stored procedure.

Thanks/E

View 1 Replies View Related

Permissions

Mar 9, 2001

what does it meant if I go and look at the permissions on a user and in one item (say a stored procedure) there is a green check giving permissions but the check cannot be removed. How can I remove that?

View 1 Replies View Related

Permissions?

Nov 1, 2004

What are the minimum permissions required to be able to read the application log in the event viewer &
run perfformance monitor? Do you have to have NT admin rights on the server?
thanks!

View 2 Replies View Related

SQL Permissions

Jun 17, 1999

To all,
I need some help understanding some things about SQL permissions. Login ID A is a login mapped to the dbo of database A and B. Login ID B is aliased to dbo. Why when running a transfer from database A to B, it runs OK when run by Login A, but fails as Login B. In the failure situation, I get error 15244, only sa or dbo can set database permissions. I thought by virtue of the aliasing I had dbo permissions.
This SQL stuff is more confusing than any TCP/IP or Cisco stuff I have ever done.

Thanks in advance,
Ed

View 2 Replies View Related

Permissions

Apr 1, 1999

Good Morning,

I have a problem with SQL Server permissions.

My Database has +/- 70 tables. A user has select permissions to +/- 10.
But I found a table where he has update permission to one table.

I tried to revoke this several times and I couldnīt revoke it.

What I have to do?

View 1 Replies View Related

SQL Permissions

Jun 24, 2002

My SQLAdmins are asking for the following:

1) Administrator access to the local box on running SQL
2) The ability to access the SQLData directory directly through drive mappings

We are attempting to create as secure an environment as possible and keep everything locked down. In my opinion, they do not need these type of accesses. They do have sa priviliges to the SQL server but I see no reason to give them Windows 2000 administrator priviliges. Also, to further the security on the servers (they are publicly accessible), we are trying to eliminate all shares including admin shares. Seems to me they should be able to accomplish everything using the SQL tools. Am I off base on this?

View 2 Replies View Related

Permissions

Dec 7, 1998

Is there a "SP_" stored procedure that will report what permissions a group and or user has?

View 1 Replies View Related

Permissions

Jul 16, 2004

I have a database with sql as the engine and access is on the client side. my problem is that when more then one person gets into the database it comes up read only. They are on sql as a users, not sure whats going on

View 2 Replies View Related

Permissions

Feb 28, 2007

How can I tell what permisisions a user or role has for a specific database?
I've queried the syspermissions table but it's not very helpful.

I've granted a user "create view" permission and would like to verify that it's in effect.

Thanks.
Mary

View 2 Replies View Related

DTS And Permissions

Feb 20, 2004

I'm developing a DTS package which will be scheduled and will write files out to a LAN share. When I execute the package manually from enterprise manager it works just fine. But when scheduled..fails with a access denied. Can someone point me towards the area I need to fix this? I'm running the SQL server under the System account.

Thanks,
E

View 2 Replies View Related

Permissions

May 22, 2008

I have a vendor that needs to remote in to our SQL 2005 Enterprise server and connect to their database. I have created them a username and password in SQL and they can VPN into our network and connect to their database using Management Studio just fine. So far so good! The issue is this: They need to be able to see the processes of an application that connects to their database. When they run 'sp_who2' all they can see is themselves running 'Management Studio'.

What else do I need to give them permission to in order for them to see all processes that are tied to their database? I need to do this without giving them permissions to other databases. I have several databases on this server.

Thanks in advance!

View 3 Replies View Related

Permissions

May 19, 2006

Yogesh writes "1. A user is member of public role and sales role.Public role has the permissions to select on all the table,and sales role,which doesn't have a select permissions on some of the tables.Will that user be able to select from all tables ?




Q 2
Describe application role and explain a scenario when you will use it ?

Q 3

I have a SP names YourSP and have the a select stmt inside the SP. I also have a user named YourUser.What permissions i have give him for accessing the SP ?"

View 7 Replies View Related

Add Permissions

Oct 21, 2006

I have a bunch of sp's I need to push out to the server. I need to grant permissions to each so that the calling application will be able to execute them. I currently open each one, and manually add the user permission. Is there a script that i can run that will do this (there are over 100 sp's)
Thanks

View 3 Replies View Related

Permissions

May 1, 2007

hi all
how cani view all permissions given to particular useris theie any query
or
do we have any sql command 4 this

Thanks in advance


Malathi Rao

View 2 Replies View Related

Permissions

Dec 15, 2006

hi all

my computer = NZ3 (sql Server)
my computer = the report server

I can design / view / publish to local host (myserver)
others in domain can only view local host (myserver) and no content

so to test added one person - as content manager
he can now see all reports - but when he goes to run
gets the error cannot create a connection to the datasource?

I am using sql server 2005 standard

where else should I be changing or setting permissions

thanks
jewel

View 4 Replies View Related

Permissions

Mar 17, 2008

I'm on SQL Server 2005 Reporting Services.

I go to the default home page http://hostname/reports


and it appears that I obviously haven't got the appropriate permissions because I have no options there to choose.

I have SA rights on this SQL Server.

Is there anything else I need to do???

View 16 Replies View Related

Permissions

Feb 6, 2008



can anyone help with the following :

1) how to give executable permission on all the store procedures to particular user/login on selected database ?
2) how to give executable permissions to all the functions in sql server 2005
3) how to give truncate table right on all the tables

please email to cqldba@gmail.com
thanks
sam

View 1 Replies View Related

Permissions

Mar 25, 2008



How do I check the permissions on a table?

Thanks

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved