General security questions....

Question

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

rajankjohn SSCertifiable Points: 5061 More actions · Answer 1

You need to create a user in the database, map it with the login created, and then provide appropriate permissions on the objects.

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 2

There is no spool command like that you have in Oracle. You can save the result to a file.

-Roy

horace-244264 Old Hand Points: 326 More actions · Answer 3

thanks for the advice!

More questions

The following code was posted earlier to allow me to list user tables

select 'grant select on ' + a.name + ' to serviceuser'

from sysobjects a where a.type = 'u'

So I assume that the type = 'u' means tables?

How do I list user views? ie what is the type code?

How do I get to the sysobjects table, so I can see how this works?

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 4

You can see all objects in sys.all_objects. It is view.

-Roy

horace-244264 Old Hand Points: 326 More actions · Answer 5

sorry to be a pain, but how do i access that in Management Studio?

I've tried a describe command, but it doesn't work

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 6

Open New Query window.

Use Midas;

Go

Select * from sys.all_objects

go

-Roy

Jorge Segarra SSCrazy Points: 2571 More actions · Answer 7

use [dbname]

select * from sys.all_objects

=============================================================
/* Backups are worthless, Restores are priceless */