Recent content by j2willi4

thanks sqlbill!

well... my understanding of it is (and i could be wrong... i'm a novice) the users log into the application... the application allows the user to connect and query the db using a generic application login... so the login to the database has 2 roles providing privileges. 1) the applicationUser...

We have a database that has several applications accessing data from it. We want to clean up the privileges that had been assigned to the public role when the developers created those apps by reassigning them to application roles all users of the apps will belong to. we aren't taking any...

yes it did... thank you yet again!

Mufasa, Thanks, i really appreciate any help you can provide... might sound kind of odd.. but I'm not actually trying to set up a guest user account on a database... I'm not an oracle dba... or even have access to the database here... but i have been tasked with comparing and documenting some...

Is there a guest user in Oracle similar to that of MSSQL? If not, is there a guest equivalent? Thanks!

oops... thought i did... sorry.

hello... I am new to db2 and am trying to understand its general structure... (How does IBM term the structure... is an instance of db2 one database with many tablespaces / tables... sort of like oracle... or is it more like SQL server with many dbs in one instance with many tables per db? I...

hello... I am new to db2 and am trying to understand its general structure... (How does IBM term the structure... is an instance of db2 one database with many tablespaces / tables... sort of like oracle... or is it more like SQL server with many dbs in one instance with many tables per db? I...

Do anyone know whether there are any stored procedures in ASE that PUBLIC has access to that would grant them access to data in a user database that a user doesn't have permissions to view?? In other words, can a user with no privileges to view information in a user-defined database be granted...

thanks!!

I am not concerned with 'should' or 'should not.' I need to figure out what it 'can' do. If 3rd party apps and DBAs didn't grant additional privs to PUBLIC, my job would be a lot simpler :) I know that in Oracle UserRole1 can be assigned to PUBLIC so that every user has the privileges of...

is it possible to assign a user defined role to the PUBLIC role? and if so, is there a simple way to check that? I have seen this in oracle and informix but cant find anything on it with SQL server.

if i have a view thats base table is local, but has columns from a remote table. PUBLIC has been granted VIEW to to all local and remote tables. Will the PUBLIC's permission to the remote table be represented if I check the permissions to the remote table? try to read that 5 times fast. :) Thanks!

by default" was intended to mean "has not been specifically granted any additional permissions" Other roles (non-PUBLIC) that grant permissions are out of scope for what i am doing... Thanks for all your help!