user permissions - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

user permissions

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-07-10 : 08:45:56

Hi Experts,
i've created a basic user with read and write permissions on all databases except system databases.

now the problem is they are unable to use sp_helptext

how can i make changes to provide the permissions to use helptext

Arnav
Even you learn 1%, Learn it with 100% confidence.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-10 : 09:43:29

Either they have to be object owner(Not recommended) or they need View definition,ALter,Control Permission.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-07-11 : 06:48:01

i didnot found those in login properties...
can you tell me how can i give them

Arnav
Even you learn 1%, Learn it with 100% confidence.

kumarshrawan01
Starting Member

2 Posts

Posted - 2008-07-11 : 07:16:40

i am using VB and Sql Server. but how to use filter data from database with store procedure

shrawan kumar malhotra

kumarshrawan01
Starting Member

2 Posts

Posted - 2008-07-11 : 07:17:35

how to make a store procedure in sql server?

shrawan kumar malhotra

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-11 : 07:20:32

quote:
Originally posted by kumarshrawan01

how to make a store procedure in sql server?

shrawan kumar malhotra

look for CREATE PROCEDURE in MSDN help or books online. ALso please dont hijact threads.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-11 : 08:40:17

quote:
Originally posted by sunsanvin

i didnot found those in login properties...
can you tell me how can i give them

Arnav
Even you learn 1%, Learn it with 100% confidence.

Right click database - properties-permission.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-11 : 08:40:42

quote:
Originally posted by kumarshrawan01

i am using VB and Sql Server. but how to use filter data from database with store procedure

shrawan kumar malhotra

Does it relate to Original post?

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-08-05 : 01:50:33

quote:
Originally posted by sodeep

Either they have to be object owner(Not recommended) or they need View definition,ALter,Control Permission.

several doubts please clarify me....
1)after this, is it necessary to restart the server?
2)providing read and write is not equal to providing insert, update, delete?

Arnav
Even you learn 1%, Learn it with 100% confidence.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-05 : 02:01:40

1. No, why would you think you'd need to restart SQL Server when you've provided permissions?
2. Read/write grants SELECT/INSERT/UPDATE/DELETE.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-08-05 : 02:12:04

thank you very much tkizer....
and what is the affect of view definition and control?

Arnav
Even you learn 1%, Learn it with 100% confidence.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-05 : 09:27:18

They can see only definition but control will allow them to control.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources